Time Calculation

[Dan1059]

Hi,

I'm new on here but have a problem with a formula I copied. As you can see from this timesheet the time that totaled automatically is 33.22 hours BUT when I manually add it it totals 33.21 hours. I'm not sure why this is but I need it to total the correct time. Any thoughts about this?

Thanks,
Dan

PS: I think I attached the timesheet file to this

Dans time.xlsx

[alansidman]

While the numbers displayed are to only two decimal places, Excel actually calculated them out to greater than two. You will need to surround the existing formulas in the round function.

ie. In cell G7 you would have: =ROUND(IF((((D7-C7)+(F7-E7))*24)>8,8,((D7-C7)+(F7-E7))*24),2)

Use this format for the remaining cells and the calculation will come to what you expect.

[Dan1059]

Hi Alan,

Thank You!! I'll plug this in later today and retest. I did not run a debug (didn't know anything about that).

~Dan

[Dan1059]

Alan,

Mission accomplished ... it works as you mentioned!!!

Thanks a bunch!

~Dan

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Dan1059]

**Done** & thanks again!!!