Converting time from hrs + muntes to whole minutes
 

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.

Converting time from hrs + muntes to whole minutes
 

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

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Linebacker" wrote in message
...
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.

Converting time from hrs + muntes to whole minutes
 

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

--
Regards
Frank Kabel
Frankfurt, Germany


Linebacker wrote:
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.