Adding Hours Worked Correctly

[CindyJ]

I'm creating a custom timesheet for our company. I have formulas adding the
hours worked in a day as =((D13-C13)+(F13-E13))*24 where D and C are morning
hours and E and F are afternoon hours and the cells are formatted as Time
1:30 PM.

My problem comes about in totaling a week. Right now, my formula of
=SUM(G9:G15) will add 8.17 + 8.17 = 16.33, but it should be 16.34 (the total
cells are format as Number to 2 decimal places).

What can I do to get my formulas to add correctly?

Thanks in advance!

 

[cm]

one or more of your formulas needs to be rounded. the 8.17 is most likely not
8.17, but several decimal places that are only formatted to display 2
decimals.

you could round this way:

=round(((D13-C13)+(F13-E13))*24,2)

 

[CindyJ]

Thank you! That seems to be the magic spell I needed - thank you so much!!!!

Cindy

 

[CellShocked]

I'm creating a custom timesheet for our company. I have formulas adding the
hours worked in a day as =((D13-C13)+(F13-E13))*24 where D and C are morning
hours and E and F are afternoon hours and the cells are formatted as Time
1:30 PM.

My problem comes about in totaling a week. Right now, my formula of
=SUM(G9:G15) will add 8.17 + 8.17 = 16.33, but it should be 16.34 (the total
cells are format as Number to 2 decimal places).

What can I do to get my formulas to add correctly?

Thanks in advance!

The formulas found in the time tracking sheet of this workbook might be
just what you are looking for. They also leave the blank if the value is
zero.

http://office.microsoft.com/en-us/templates/TC300053871033.aspx?CategoryID=CT101172771033&av=ZXL000