Times from sheet to sheet

  • Thread starter Thread starter Chris Watson
  • Start date Start date
C

Chris Watson

Hi Me again

I have 8 sheets all with differant names eg Sunday, Monday etc and in
Cell C3 on all sheets are times.
Im wanting to add all the times together on a cell on the 8th sheet,
does anybody know the formula please.
Regards Chris
 
Try =SUM(Sunday:Saturday!C3)

, if the total will exceed 24 hours you'll need to use a custom format
(CTRL+1, Number tab) such as [h]:mm.

Rgds,
Andy
 
Back
Top