Hello all,

I have lots of worksheets, which I have named after my staff (e.g. Joe.B,
Joanne.B)

All the sheets are identical.

The sheets are tracking individuals time on cells B6 and B7.

I have another sheet called 'front sheet' that I want to display the total
of all the B6's and B7's for all my staff.

The problem is, is that B6 and B7 (on the employee sheets) both contain
formulas and for some strange reason excel is giving me funny totals.

The numbers on the employee sheets are fine but the total I get on the Front
Sheet are very odd.

These cells are all in time format too...

If anyone can help me with this I'd be ever so greatful.

Paul

Make sure the time format you are using doesn't have an asterix (*) as I have
tried adding times and it doesn't work with time formats marked with '*'


"paule1982" wrote:

Hello all,

I have lots of worksheets, which I have named after my staff (e.g. Joe.B,
Joanne.B)

All the sheets are identical.

The sheets are tracking individuals time on cells B6 and B7.

I have another sheet called 'front sheet' that I want to display the total
of all the B6's and B7's for all my staff.

The problem is, is that B6 and B7 (on the employee sheets) both contain
formulas and for some strange reason excel is giving me funny totals.

The numbers on the employee sheets are fine but the total I get on the Front
Sheet are very odd.

These cells are all in time format too...

If anyone can help me with this I'd be ever so greatful.

Paul

Have you checked Tools Options, on the Calculation tab to see if Automatic
is selected (instead of Manual)?

"paule1982" wrote:

Hello all,

I have lots of worksheets, which I have named after my staff (e.g. Joe.B,
Joanne.B)

All the sheets are identical.

The sheets are tracking individuals time on cells B6 and B7.

I have another sheet called 'front sheet' that I want to display the total
of all the B6's and B7's for all my staff.

The problem is, is that B6 and B7 (on the employee sheets) both contain
formulas and for some strange reason excel is giving me funny totals.

The numbers on the employee sheets are fine but the total I get on the Front
Sheet are very odd.

These cells are all in time format too...

If anyone can help me with this I'd be ever so greatful.

Paul