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).
39 freelancers are bidding on average $21 for this job
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.
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...