Try a custom format of the resultant cell:

Format/Cells/Custom

and then enter: dd:hh:mm:ss

This assumes you want to show the # of days, hour, minute and seconds


"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