Currently Being ModeratedMar 20, 2013 8:33 PM (in response to 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:
C2 is formatted as Duration h (hours) m (minutes). You can change the display to show 10:15
Currently Being ModeratedApr 1, 2013 7:03 PM (in response to Yellowbox)
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!!
Currently Being ModeratedApr 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.