Does anyone know of a way that a cell in excel that contains hh:mm:ss can be converted to minutes?

Question

Does anyone know of a way that a cell in excel that contains hh:mm:ss can be converted to minutes?

Answer 1

Assuming that your hh:mm:ss is recognized by excel as time (and not just a text cell), then you can simply multiply the time by 1440 to get a total in minutes.  You will probably need to change the format of the formula cell to "general", because excel will probably change the format match the hh:mm:ss.

=A1 * 1440

For example, if you have 12:30:00 displayed in cell A1, the cell actually contains the value 0.52.  Excel stores time as a decimal representing fraction of a day.  12:30 is equal to 0.52.  Multiply 12:30 or 0.52 by 1440 and you get 750 minutes.

Answer 2

Just give the cell one of the two following formats

[mm]:ss  if you want the seconds to show

[mm]  if you want the seconds omitted

18:15:45 would display as 1095:45 or 1095

Remember that the internal value stored by Excel is a number with the integer part being the number of days since 1/1/1900 and the decimal part being the fractional part of a day so no conversion is ever required.  You only need to (and only can) change the date and/or time format.