Format cell with custom format: [h]:mm or [hh]:mm
The brackets prevent 24 modulation
The first will show for example 9:25 and 15:25
The second will show 09:25 and 15:25
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"nickq2" wrote in message
...
I'm trying to do calculations involving hours & minutes. Whenever the
answer
is more than 24 hours, Excel automatically subtracts 24 from the answer -
27:15 becomes 03:15. I don't want to use decimals instead, so is it
possible
to get round this?
Thanks