Adding up Times
 

I am trying to do a timesheet to calculate the hours worked each day (Start
Work, End Work and Total Hours) and then total the hours for the week. I
have managed to do the first part by using =TEXT(D6-C6,"[h]:mm") which works
fine, but I can't add up the daily totals to give a weekly total. The cells
are all formatted as [h]:mm.

Any suggestions would be welcome - Thanks!

Lisa,

Just use =D6-C6, and format (FormatCellsCustom) as "[h]:mm. Adding these
up will then be simple.

--

HTH

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


"Lisa" wrote in message
...
I am trying to do a timesheet to calculate the hours worked each day
(Start
Work, End Work and Total Hours) and then total the hours for the week. I
have managed to do the first part by using =TEXT(D6-C6,"[h]:mm") which
works
fine, but I can't add up the daily totals to give a weekly total. The
cells
are all formatted as [h]:mm.

Any suggestions would be welcome - Thanks!

Thank you very much Bob - works fine! I knew I must have gone wrong
somewhere - I'd tried so many things I confused myself!

Lisa

"Bob Phillips" wrote in message
...
Lisa,

Just use =D6-C6, and format (FormatCellsCustom) as "[h]:mm. Adding these
up will then be simple.

--

HTH

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


"Lisa" wrote in message
...
I am trying to do a timesheet to calculate the hours worked each day
(Start
Work, End Work and Total Hours) and then total the hours for the week. I
have managed to do the first part by using =TEXT(D6-C6,"[h]:mm") which
works
fine, but I can't add up the daily totals to give a weekly total. The
cells
are all formatted as [h]:mm.

Any suggestions would be welcome - Thanks!