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)
|