Converting Hours an minutes just into minutes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Six Sigma Blackbelt - 31 Oct 2006 23:49 GMT

Is thier a formula to use to change hous and minutes, just into minutes ex:
01:30 (1 hour and 30 minutes) into 90 minutes. And how do you format the
cells.

Thank you

Reply to this Message

Roger Govier - 01 Nov 2006 00:00 GMT

Hi

Excel stores times as fractions of a day.
Therefore to convert to hours, multiply by 24 (result 1.5)
To convert to minutes multiply by 1440 (24 * 60 ) (result 90)
Format cell as General.

Signature

Regards

Roger Govier

> Is thier a formula to use to change hous and minutes, just into
> minutes ex:
[quoted text clipped - 3 lines]
>
> Thank you

Reply to this Message

Earl Kiosterud - 01 Nov 2006 00:12 GMT

Belt,

If you have a true date-time serial, you can format it so show just minutes.
Format - Cells - Number - Custom:

[m] or
[mm]

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

> Is thier a formula to use to change hous and minutes, just into minutes
> ex:
> 01:30 (1 hour and 30 minutes) into 90 minutes. And how do you format the
> cells.
>
> Thank you

Reply to this Message

Rate this thread: