"OscarCVox" wrote in message
...
Why not format the cells to a time format thus-
Format - cells - time - 37:30:55
This will give time in hours minutes and seconds that can be added
Sorry excell dont work like that. If you try to enter say 1hr 30min as 1.5
it trys to use it as a date function and displays 12:00:00 and if you try to
add times it treats them also as dates such that 12:00:00 + 12:00:00 =
0:00:00.
I use two columns and add one mod 60 etc.
Peter.
|