I use Excel 2003.
I have a workbook sent to me, but can't consult the author.
I want to construct a pivot table.

My basic table comes out as:

A B
1 Drop Page Fields Here
2
3 Sum of MZone Total
4 Total 00:00:00

[B4] presents as 00:00:00 because its format is Time.
I might expect the default format to be General.
I don't expect it to be time.
In the fx formula field, [B4] presents as 23/01/1906 00:00:00.
If I change the format to General, [B4] presents as 2215.
I guess 23/01/1906 is 2315 days after date 0.

What should I look at in the data?
On the data sheet, the "default" cell format is also time.
Occupied cells format is General.
--
Walter Briscoe