3 Replies Latest reply: Apr 1, 2013 9:52 PM by Yellowbox
NorthrailDrive Level 1 Level 1 (0 points)

I created a simple workbook for calculating hours worked. I am entering the start time, end time, and using the DUR2HOURS formula to calculate the duration. For some reason the calculation is wrong. I am sure it is somethign simple, but I could not find an answer and it has been bothering me for a couple of days now. Here is an example of what is happening:


Start Time     |     End Time     |     Duration

7:15 AM               5:30 PM               10.25  (formula: =DUR2HOURS(ENDTIME - STARTTIME)


The duration in this example should be 10.15?





MacBook, Mac OS X (10.4.8)