Time log adding time from separate sheets
 

I have a time log I am keeping on separate clients however, I would like
to create a sheet that adds up time from each client sheet.

How do I pull time from sheet 1 and time from sheet 2 to create total
time on sheet 3?


--
teastman
------------------------------------------------------------------------
teastman's Profile: http://www.excelforum.com/member.php...o&userid=30030
View this thread: http://www.excelforum.com/showthread...hreadid=497161

Time log adding time from separate sheets
 

Try something like

='Sheet1'!A1 + 'Sheet2'!A1
or
=SUM('FirstSheet':'LastSheet'!A1)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"teastman"
wrote in
message
...

I have a time log I am keeping on separate clients however, I
would like
to create a sheet that adds up time from each client sheet.

How do I pull time from sheet 1 and time from sheet 2 to create
total
time on sheet 3?


--
teastman
------------------------------------------------------------------------
teastman's Profile:
http://www.excelforum.com/member.php...o&userid=30030
View this thread:
http://www.excelforum.com/showthread...hreadid=497161