Adding up Times

[Lisa]

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!

 

[Bob Phillips]

Lisa,

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

--

HTH

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

 

[Lisa]

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

Lisa,

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

--

HTH

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

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!