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
