Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting days, hours and minutes to minutes | New Users to Excel | |||
Total Minutes and converting to Hours and Minutes | Excel Discussion (Misc queries) | |||
Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
Converting hours:minutes:seconds to just minutes | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) |