How to calculate time in 1/100 decimal while it is entered 1/60
Entering time in excel to create a time sheet 7.00am start 14.30 finish
would give a figure of 7.30 hrs as worked , actually 7.5 hrs is the hours
worked. How does one achieve this answer
|