ADDING TIMES

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

--
HTH

Bob Phillips

"John C. Harris, MPA" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

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
"John C. Harris, MPA" <[email protected]> wrote in message
news:[email protected]...
>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
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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
> "John C. Harris, MPA" <[email protected]> wrote in message
> news:[email protected]...
> >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
> >
>
>

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
"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>> "John C. Harris, MPA" <[email protected]> wrote in message
>> news:[email protected]...
>> >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
>> >
>>
>>
>
>

All I did was keep you looking <g>

Bob

"John C. Harris, MPA" <[email protected]> wrote in message
news:eFC%[email protected]...
> 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
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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
> >> "John C. Harris, MPA" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >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
> >> >
> >>
> >>
> >
> >
>
>

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

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

--
HTH

Bob Phillips

"John C. Harris, MPA" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

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
"John C. Harris, MPA" <[email protected]> wrote in message
news:[email protected]...
>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
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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
> "John C. Harris, MPA" <[email protected]> wrote in message
> news:[email protected]...
> >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
> >
>
>

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
"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>> "John C. Harris, MPA" <[email protected]> wrote in message
>> news:[email protected]...
>> >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
>> >
>>
>>
>
>

All I did was keep you looking <g>

Bob

"John C. Harris, MPA" <[email protected]> wrote in message
news:eFC%[email protected]...
> 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
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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
> >> "John C. Harris, MPA" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >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
> >> >
> >>
> >>
> >
> >
>
>