Summing times works fine.

If you enter real times (8:15:14:30, etc.) and format the total cell as
[h]:mm it will show the result you expect.

What does your data look like?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Bikertyke" wrote in message
...
It appears that Excel will not sum a column of calculated times. My time
column is the product of my start time and finish time minus my lunch time
and therefore a calculation rather than a straight forward number. It
works
fine if I enter the pure number but thats not what a spreadsheet is all
about.....is it?
Is this usual.


"Bikertyke" wrote in message
...
Why when a try to sum a number of time entries on a spreadsheet who's
total
should be around 192 (worked hours per month) does the total appear as
00:00.
This is despite uning the [hh]:mm format, timesing the whole by 24 and
numerous other 'ideas'
Any help greatly apreciated.