i want to calculate times worked each day, eg: a2 = 8:45 and a3 = 16:30. But I need it to calculate instead of it equalling 7.45hrs I need to convert it to 100 minute, eg it should calculate to 7.75. any suggestions?
Share
Computing.net: Question & Answers Forum
Try this formula:
Format the cell with the formula as a number with two decimal places.
The formula returns the complete hours plus the minutes expressed as a fraction of an hour.
Regards