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?
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?
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"
<[email protected]> wrote in
message
news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks