Can I get Excel to calculate hours:minutes when sum exceeds 24?

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

Use a custom format of [hh]:mm then the hours will just get bigger than 24

Regards

Dav

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" <[email protected]> wrote in message
news:[email protected]...
> 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

Just format the cell with the formula in as:

[h]:mm

This allows times like 27:15 to be displayed.

Hope this helps.

Pete

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" <[email protected]> wrote in message
news:[email protected]...
> 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

Absolutely perfect!! Thank you to all of you.

"Larry S" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>