Converting time from hrs + muntes to whole minutes

[Guest]

I'm in the transportation career field and would like to formulate a cell to convert time into whole minutes (i.e., 5:28am = x amount of minutes). This chart would be used to show an "On time Start precentile.

 

[Norman Harker]

Hi Linebacker

Use
=A1*(24*60)
Format general.


Time in Excel is recorded as the decimal part of 1 day hence
multiplying by (24*60) to get minutes.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Frank Kabel]

Hi
try
=A1*24*60
and format the resulting cell as 'General' or 'Number'
also have a look at
http://www.cpearson.com/excel/datetime.htm