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!
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!