Converting hours & minutes to whole minutes
 

Ref: Transportation:
Would like to take actual start time and divide into
scheduled start time for percentile. Need Formula for
converting hrs & minutes into whole minutes.
(i.e., 5:28a = X minutes)

Converting hours & minutes to whole minutes
 

Hi

There are 1440 minutes in a day, so multiply by that:
=A1*1440
format result cell as decimal.

HTH. Best wishes Harald

"Linebacker" skrev i melding
...
Ref: Transportation:
Would like to take actual start time and divide into
scheduled start time for percentile. Need Formula for
converting hrs & minutes into whole minutes.
(i.e., 5:28a = X minutes)

Converting hours & minutes to whole minutes
 

numMin = TimeValue("5:28a")*24*60

from the immediate window:

numMin = TimeValue("5:28a")*24*60
? numMin
328


Not sure what this show you, but:

ActualStart = TimeValue("5:28a")
ScheduledStart = TimeValue("5:00a")
? format((actualstart - scheduledstart)/scheduledStart,"0.0%")
9.3%

--
Regards,
Tom Ogilvy




"Linebacker" wrote in message
...
Ref: Transportation:
Would like to take actual start time and divide into
scheduled start time for percentile. Need Formula for
converting hrs & minutes into whole minutes.
(i.e., 5:28a = X minutes)

Converting hours & minutes to whole minutes
 

Thank you very much. This has puzzled me for two months
trying to find the right formula without using two cells
-----Original Message-----
Hi

There are 1440 minutes in a day, so multiply by that:
=A1*1440
format result cell as decimal.

HTH. Best wishes Harald

"Linebacker" skrev
i melding
...
Ref: Transportation:
Would like to take actual start time and divide into
scheduled start time for percentile. Need Formula for
converting hrs & minutes into whole minutes.
(i.e., 5:28a = X minutes)


.