Cancelled

Complete Excel spreadsheet formulas to recalculate time values into hour (number) values

I have created a roster which includes name, location, start time, finish time, break, total hours and net hours. I have completed most of the spreadsheet however I can't work out how to calculate final hours worked as a real number (e.g. 10 or 10.5 etc).

Simply require someone to enter the correct formulas/formatting so that the sheet will automatically calculate hours worked once start time, finish time and break have been entered. (NB there are 2 tabs on the worksheet).

Skills: Excel

See more: excel sheet formatting, net spreadsheet, work hours spreadsheet, excel spreadsheet formulas macros, spreadsheet net, spreadsheet hours worked, excel spreadsheet time, real time excel, roster work, roster hours excel, complete excel spreadsheet, spreadsheet calculate, convert excel spreadsheet formulas webpage, work time calculate, roster sheet, net sheet spreadsheet, formulas excel spreadsheet, excel worksheet net, excel spreadsheet work completed, excel spreadsheet formulas webpage, excel spreadsheet formulas, correct name excel spreadsheet, excel work roster, excel roster, excel count patients time hour

About the Employer:
( 18 reviews ) Kurmond, Australia

Project ID: #6846461

39 freelancers are bidding on average $21 for this job

Teloquence

Hello, I am top excel developer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your refere More

$20 AUD in 0 days
(234 Reviews)
7.0
zExcel

Hi, I'll be happy to help you with this project. .........................................................................

$45 AUD in 1 day
(120 Reviews)
6.6
priyal1997

Dear Sir/Madam, I'm happy to help you on this task. I am an expert in advanced excel features and have already done lots of similar assignments. I am happy to complete this task before you offer me the job. Pls reply More

$25 AUD in 1 day
(132 Reviews)
6.4
deepbluetech

A proposal has not yet been provided

$30 AUD in 1 day
(136 Reviews)
6.4
jaylancer43

Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am amo More

$30 AUD in 1 day
(92 Reviews)
6.1
maverick44000

Hi there. I am ready to get the formulas corrected. It shall not take me more than 15 mins. Kindly discuss. Regards.

$30 AUD in 1 day
(44 Reviews)
6.0
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou More

$24 AUD in 0 days
(78 Reviews)
5.9
binaryromel

Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, FARZANA PINKY.

$25 AUD in 0 days
(70 Reviews)
5.8
funnyhoney

PMP, MBA and excel pro here. Worked with large and complex data sets to generate reports, analysis and presentation.

$34 AUD in 1 day
(9 Reviews)
5.4
aarifakhtar

Hi: Here's your formula: [url removed, login to view] Please pay me if you want to, otherwise happy to help

$15 AUD in 0 days
(38 Reviews)
5.3
expertatwork

I believe this is a simple formula, please reply, thank you !

$25 AUD in 1 day
(74 Reviews)
5.1
dragos1910d

A proposal has not yet been provided

$20 AUD in 0 days
(46 Reviews)
5.0
hdlong66

Hello, Your file (both spreadsheets) is ready. Kindly check it here [url removed, login to view] Thank you

$15 AUD in 1 day
(39 Reviews)
4.8
dank111

Hi, My name is Dan. I am an expert in excel. I have done the formula and ready to share whenever you are. Please message me. Thanks & Regards Dan

$25 AUD in 0 days
(9 Reviews)
4.1
raghav1101

Hi I would love to work on this project. I can provide the solution right away. Please contact with further details if interested. Regards Raghav Bansal

$10 AUD in 0 days
(16 Reviews)
3.9
tranxuanhao

My name's Hao from Vietnam.I provide services with enthusiasm, creativity, [url removed, login to view] pay until you are satisfied with my quality services and reach your purposes. My Services: Data Entry ++ Excel ++ Web Research ++ More

$17 AUD in 0 days
(17 Reviews)
3.9
ElaineTeo

I have skill in Microsoft Excel, formula for Vlookup, If, And, Or, Sumif(s), Countif(s), and how to combine multiple formulas and use Sort, Filters, Data Validation, Conditional Formatting, Pivot tables and also Excel More

$18 AUD in 1 day
(16 Reviews)
3.8
tasleem83

I have gone through the description. I am very much interested to work on your project. I’ll provide you the work as per your requirement with in a particular time frame. So let’s start and finish it FAST. (tasleemnaz More

$30 AUD in 1 day
(14 Reviews)
3.6
P0L

Hello, I'm an excel expert. Please check my profile and contact me to discuss the issue. Regards.... Cell F6 =HOUR([@FINISH]-[@START]+24)&"."&MINUTE([@FINISH])*100/60 Checked that? Well, that's the solution...

$20 AUD in 0 days
(9 Reviews)
3.3
TonmoyRoy111

Dear Sir, I ensure you of completing the project within the specified time. I have a previous experience of Data Modification work in Excel using Macro. Besides I am an Electrical Engineer and currently working in More

$25 AUD in 1 day
(5 Reviews)
2.2