ADDING TIMES

[John C. Harris, MPA]

I have a worksheet where I am having a time in and time ut calculated to
hours owrked for a week. At the end I need to add the total hours of each
day for a weekly total. I have everythig working except the adding od the
week, whihc is not giving me the correct answers. I have checked the
formatting of all the cells, and followed the guides available in excel
help, but cannot get it to work. The odd this is when I just add two days
(i.e. Monday and Tuesday) it works fine. Only fouls up when I add the third
day to it.

example format:

Semester 1 Monday Tuesday Wednesday Thursday Friday Total Hrs
Week Of: In Out Hrs In Out Hrs In Out Hrs In Out Hrs In Out Hrs
8/8/2005 8:32 17:05 8:33 8:10 17:32 9:22 8:15 16:25 8:10 8:00 16:00
8:00 8:12 13:00 4:48 14:53


Thanks in advance

 

[Bob Phillips]

You say you have checked the formatting, but as it goes wrong on 3 days, it
sounds like formatting. Have you formatted the result cell as [hh]:mm

 

[John C. Harris, MPA]

I sure did. That's why it is confusing me. Van't figure out why it is not
working.

Another thing I found though: If I take the Sum formula =SUM(A1, B1, C1) and
multiply it by 24, =SUM(A1, B1, C1)*24, and change the cell format to a
number, I get the correct hours in decimal format (i.e. 44:33 changes to
44.6).

 

[Bob Phillips]

That just proves that it has the correct calculation. Therefore, [hh]:mm
should work.

I have just duplicated your data and I get 38:53 with that format.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[John C. Harris, MPA]

I got it working. I cleared everything and re-entered formatting and it
worked. Must have been something hiding in there. Thanks for the help.

--
John C. Harris, MPA
JCZ Consulting Services, LLC

That just proves that it has the correct calculation. Therefore, [hh]:mm
should work.

I have just duplicated your data and I get 38:53 with that format.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

All I did was keep you looking <g>

Bob

I got it working. I cleared everything and re-entered formatting and it
worked. Must have been something hiding in there. Thanks for the help.

--
John C. Harris, MPA
JCZ Consulting Services, LLC

That just proves that it has the correct calculation. Therefore, [hh]:mm
should work.

I have just duplicated your data and I get 38:53 with that format.

--

HTH

RP
(remove nothere from the email address if mailing direct)

I sure did. That's why it is confusing me. Van't figure out why it is not
working.

Another thing I found though: If I take the Sum formula =SUM(A1, B1,

C1)
and

multiply it by 24, =SUM(A1, B1, C1)*24, and change the cell format to a
number, I get the correct hours in decimal format (i.e. 44:33 changes to
44.6).

--
John C. Harris, MPA
JCZ Consulting Services, LLC
I have a worksheet where I am having a time in and time ut calculated to
hours owrked for a week. At the end I need to add the total hours of
each
day for a weekly total. I have everythig working except the adding od
the
week, whihc is not giving me the correct answers. I have checked the
formatting of all the cells, and followed the guides available in excel
help, but cannot get it to work. The odd this is when I just add two
days
(i.e. Monday and Tuesday) it works fine. Only fouls up when I add the third
day to it.

example format:

Semester 1 Monday Tuesday Wednesday Thursday Friday Total Hrs
Week Of: In Out Hrs In Out Hrs In Out Hrs In Out Hrs In Out Hrs
8/8/2005 8:32 17:05 8:33 8:10 17:32 9:22 8:15 16:25 8:10 8:00
16:00
8:00 8:12 13:00 4:48 14:53


Thanks in advance

--


John C. Harris, MPA
JCZ Consulting Services, LLC