software

I'm trying to do calculations involving hours amp; 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

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

quot;nickq2quot; gt; wrote in message
...
gt; I'm trying to do calculations involving hours amp; minutes. Whenever the
gt; answer
gt; is more than 24 hours, Excel automatically subtracts 24 from the answer -
gt; 27:15 becomes 03:15. I don't want to use decimals instead, so is it
gt; possible
gt; to get round this?
gt; Thanks
Just format the cell with the formula in as:

[h]:mm

This allows times like 27:15 to be displayed.

Hope this helps.

PeteTry 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 secondsquot;nickq2quot; gt; wrote in message
...
gt; I'm trying to do calculations involving hours amp; minutes. Whenever the
gt; answer
gt; is more than 24 hours, Excel automatically subtracts 24 from the answer -
gt; 27:15 becomes 03:15. I don't want to use decimals instead, so is it
gt; possible
gt; to get round this?
gt; Thanks

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

Regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=542912Absolutely perfect!! Thank you to all of you.

quot;Larry Squot; wrote:

gt; Try a custom format of the resultant cell:
gt;
gt; Format/Cells/Custom
gt;
gt; and then enter: dd:hh:mm:ss
gt;
gt; This assumes you want to show the # of days, hour, minute and seconds
gt;
gt;
gt; quot;nickq2quot; gt; wrote in message
gt; ...
gt; gt; I'm trying to do calculations involving hours amp; minutes. Whenever the
gt; gt; answer
gt; gt; is more than 24 hours, Excel automatically subtracts 24 from the answer -
gt; gt; 27:15 becomes 03:15. I don't want to use decimals instead, so is it
gt; gt; possible
gt; gt; to get round this?
gt; gt; Thanks
gt;
gt;
gt;