converting time to number
Posted by Jaime Francisco on October 24, 2001 2:17 PM
I need to convert time in the format of 31:28:00 to one value representing minutes or seconds.
Anyone can help me out?
Posted by Aladin Akyurek on October 24, 2001 2:59 PM
=A1*1440
where A1 houses the time to convert.
Format the cell of the formula as General.
Is this what you're looking for?
Aladin
