Time Calculation

[lim]

How to change the time from minutes:second to ##.## minutes? For example:

50 minutes and 30 second in a cell as 50:30, and want to convert as 50.5?

Thank you.

[stvgarner]

Is this formatted as time or is the format of the cell text with the 50:30?

If it is text something like below should work.

=LEFT(C9,FIND(":",C9)-1)&"."&((MID(C9,FIND(":",C9)+1,LEN(C9)-FIND(":",C9))/60)*100)

I can't think of anything if this is formatted as time.

[RES]

If you multiply the time value by the number of minutes in a day and format as general you should get what you need.

eg. 50:30 is actually stored as 0.003819444

so =C9*24*60 formated as general (or a number) will show
5.5 as you need

hope this helps

RES

[lim]

Here is what I got this format: if you have 50:30 in a text file, then you copy & paste into a cell in Excel. The type will be 'Time' field.

I tried both suggestions, but not work. Any other thought?

[stvgarner]

As far as the text version goes, before you copy it into Excel format the entire column as text. That way when you paste in the number from the text file it should come over as text and show as 50:30 in the cell. Then try the text formula.