Did you see my post ?

Steve


On Mon, 27 Nov 2006 09:30:02 -0000, Bikertyke
wrote:

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.

--
Steve (3)