Sky_Captain
Adding time in excell is not that straight forward as what you see in the cell is not what it is actually working with. Excell works with decimal time and as soon as you go over 24 hrs it exceeds the number the format can display so it reverts to 0 for the 24 and displays the remainder.
one way would be to format a cell to time and then the cell next to it you can format as general and make it equal the cell formatted as time. by entering times in the first cell you can see what values are being worked with and you can then work out the formula from there.
If I get time I will have a play and get back to you, assuming nobody else answers this first.
R4
Edited to add
Doh!
You don’t want to manipulate the figures you just want to add them up and have them display correctly.
In the cell format, use custom and instead of h:mm use [h]:mm (must be square brackets) and you should achieve the desired result.
R4
Last edited by R4+Z; 16th December 2004 at 03:18.