View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Chip Pearson
 
Posts: n/a
Default 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