🚀 go-pugleaf

Brian.Milner@brunel.ac.uk (Brian D Milner) writes:


>I am trying to add up a series of times in an Excel 4.0 spreadsheet.

>The times are written thus:

>        00:50:55
>        09:11:13
>        23:05:59

>i.e. hours:minutes:seconds.     Excel recognises that, and adds them
>up as hours:minutes:seconds; but if the total is greater than (09?)
>hours, is gives the sum as '0'!

Excel's time format will only handle upto 24 hours before it rolls
around to 00:00:00 again.  Actually it doesn't roll around but adds
1 to the date. If you set the number format to dd/mm/yy hh:mm:ss you
will see what I mean.  I have writen a formula that will add up times
in excess of 24 hours.  It does this by converting the hh:mm:ss number
to a decimal number and displaying it as hh.mm.  The formula is quite
large and messy.  I don't have it here right now but if anyone's
interested I'll post it.


Dean Cording