View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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)