Oh, ok. I misunderstood what you had typed. My mistake. I have no idea
why it was giving me 120.00.

I still don't understand why you have to multiply the time by 24hours. I
entered the value in hours. 6hours. Why doesn't 13/6:24 (B2/B1) give me
the 2.03?


"Duke Carey" wrote:

I could have been clearer - using your numbers col C should NOT have shown
120 (as your example stated), it should have shown 48.75. After multiplying
the time value by 24 to get actual hours, the answer should have been a
little over 2