Change Time format into Minutes

[Guest]

Hi

I converted a .txt file into excel and there is some discrepancies as follows

the format for a cell is [h]:mm and what is displayed in the fx toolbar is, for example, 09/01/1900 09:41:00 but what is actually displayed in the cell is 225:41.

Actually it is supposed to be mm:ss, and now i'd like to convert the amount into exact minutes because I'm supposed to calculate the total usuage cost. How do I change this particular cell into minutes

Thanks!

 

[Frank Kabel]

Hi
use the custom format
[mm]:ss
for these cells

If you want to calculate with minutes (and your time is in cell A1) use
=A1*24*60 * some_value

 

[Jerry W. Lewis]

All Excel dates/times are stored as integers since 1900, with the hours
in the day as decimal fractions of a day. Thus 225 hours and 41 minutes
is 9 days, 9 hours, and 41 minutes, which is stored internally as 9
+9/24 +41/24/60 = 9.40347222222222 (with General format). To convert it
to minutes, just multiply by 1440 = 24*60 and format as a number.

Jerry