Time log adding time from separate sheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

teastman - 31 Dec 2005 15:57 GMT

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?

Signature

teastman

Reply to this Message

Chip Pearson - 31 Dec 2005 16:14 GMT

Try something like

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

Signature

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

"teastman"

>
> I have a time log I am keeping on separate clients however, I
[quoted text clipped - 4 lines]
> total
> time on sheet 3?

Reply to this Message