Divide, not times

cells with say 8,8.5,7,9.25,10 ... etc will add up to a figure like 192

Cells need to be in fractions of a day to ie 8/24, 9/24 to be able to
display them as hh:mm

If you are happy with the individual ones being shown as decimal hours, ie
8.5
rather than 8:30 - leave these cells as they are.

The sum cell just needs to be converted
so should be =sum(CellWithHoursValues)/24

Steve


On Mon, 27 Nov 2006 08:50:01 -0000, Bikertyke
wrote:

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.