Adding totals from numerous worksheets

[Guest]

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

 

[Ardus Petus]

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

HTH

 

[Guest]

Hi there,

Yes I did!

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

HTH
--
AP

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