Times from sheet to sheet

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
 
A

Andy Brown

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
Lookup whole sheet and add datas from specified date to end date 0
Sumif apllying to all sheets in workbook 2
trouble with (complicated) vlookup searching another workbook 2
VBA Coding Help for Beginner 0
Vlookup and return sheet name also 2
Duplicate Mail Merge Record Every Time 5
IF validation for time totaling 2

Top