Adding totals from numerous worksheets
 

Hi guys,

I have lots of worksheets in use and each sheet represents an employee. All
the sheets are identical too.

Cell B6 and B7 show me (in time format) how much time I owe that employee
and how much time they owe me.

On sheet #1 I want a grand total for B6 and B7 so that at a quick glance I
can see how much time I owe and vice versa.

The formula works and shows me on sheet #1 at B1 that I owe 35:30hrs.

When I enter data into B7 on an employee's sheet (e.g. they owe me 3:00 hrs)

Rather than display the B1 (total time i owe) 35:30hrs and B2 (total time
owed to me) 3:00, excel deducts the 3:00hrs from the 35:30... thus displaying
in B1 32:30 and in B2 #####

I have checked the formulas and they are fine.

Any ideas what it could be?

Paul

Adding totals from numerous worksheets
 

Did you format your TOTAL cells as [h]:mm ?

HTH
--
AP

"paule1982" a écrit dans le message de
...
Hi guys,

I have lots of worksheets in use and each sheet represents an employee.
All
the sheets are identical too.

Cell B6 and B7 show me (in time format) how much time I owe that employee
and how much time they owe me.

On sheet #1 I want a grand total for B6 and B7 so that at a quick glance I
can see how much time I owe and vice versa.

The formula works and shows me on sheet #1 at B1 that I owe 35:30hrs.

When I enter data into B7 on an employee's sheet (e.g. they owe me 3:00
hrs)

Rather than display the B1 (total time i owe) 35:30hrs and B2 (total time
owed to me) 3:00, excel deducts the 3:00hrs from the 35:30... thus
displaying
in B1 32:30 and in B2 #####

I have checked the formulas and they are fine.

Any ideas what it could be?

Paul

Adding totals from numerous worksheets
 

Hi there,

Yes I did!

"Ardus Petus" wrote:

Did you format your TOTAL cells as [h]:mm ?

HTH
--
AP

"paule1982" a écrit dans le message de
...
Hi guys,

I have lots of worksheets in use and each sheet represents an employee.
All
the sheets are identical too.

Cell B6 and B7 show me (in time format) how much time I owe that employee
and how much time they owe me.

On sheet #1 I want a grand total for B6 and B7 so that at a quick glance I
can see how much time I owe and vice versa.

The formula works and shows me on sheet #1 at B1 that I owe 35:30hrs.

When I enter data into B7 on an employee's sheet (e.g. they owe me 3:00
hrs)

Rather than display the B1 (total time i owe) 35:30hrs and B2 (total time
owed to me) 3:00, excel deducts the 3:00hrs from the 35:30... thus
displaying
in B1 32:30 and in B2 #####

I have checked the formulas and they are fine.

Any ideas what it could be?

Paul