Formulas


Posted by Brian J. Kayzar on September 10, 2001 9:04 AM

I am trying to convert hours to minutes, for example I have a total elasped time of 00:04:35 recoreded in one cell (a calculation from two other cells). I would like to convert it to total minutes elasped and have it in another cell. How can I do this?

Posted by Juan Pablo on September 10, 2001 9:08 AM

Format [mm]:ss

Just format the cell to [mm]:ss and you're done.

Juan Pablo



Posted by IML on September 10, 2001 9:33 AM

Or

multipy it by 1440. Portion of day *24 hours * 60 mins