Adding Hours Worked Correctly

  • Thread starter Thread starter CindyJ
  • Start date Start date
C

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!
 
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)
 
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!
Click to expand...


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
 
Back
Top