can someone help me with a simple duration calculation?

Question

can someone help me with a simple duration calculation?

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?

Thanks,

Nate

MacBook, Mac OS X (10.4.8)

Posted on Mar 20, 2013 7:25 PM

Reply

Answer 1

Best reply

Yellowbox

Level 7

20,383 points

Mar 20, 2013 8:33 PM in response to NorthrailDrive

Hi NorthrailDrive,

DUR2HOURS gives the value in decimal hours, not hours:minutes.

Your answer (in decimal hours) is correct (10.25, or ten and a quarter hours).

Cell C2 contains the formula you need to calculate a duration:

=B2-A2

C2 is formatted as Duration h (hours) m (minutes). You can change the display to show 10:15

Regards,

Ian.

Reply

Answer 2

Apr 1, 2013 7:03 PM in response to Yellowbox

Ian,

Thank You! I was able to figure it out with your help. I was also calculating the wages off of the decimal number, which I had to change to minutes in order to caculate the correct wage. Thanks Again!!

Reply

Answer 3

Yellowbox

Level 7

20,383 points

Apr 1, 2013 9:52 PM in response to NorthrailDrive

My pleasure. Thanks for the feedback and tick.

BTW, there is nothing wrong with your method.

wage = decimal hours times hourly rate.

Regards,

Ian.

Reply