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

About the Employer:
( 18 reviews ) Kurmond, Australia

Project ID: #6846461

39 freelancers are bidding on average $21 for this job


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)

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

$45 AUD in 1 day
(120 Reviews)

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)

A proposal has not yet been provided

$30 AUD in 1 day
(136 Reviews)

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)

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)

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)

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)

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)

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

$15 AUD in 0 days
(38 Reviews)

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

$25 AUD in 1 day
(74 Reviews)

A proposal has not yet been provided

$20 AUD in 0 days
(46 Reviews)

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

$15 AUD in 1 day
(39 Reviews)

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)

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)

My name's Hao from Vietnam.I provide services with enthusiasm, creativity, [login to view URL] 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)

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)

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)

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)

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)