MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


where A1 houses the time to convert.

Format the cell of the formula as General.

Is this what you're looking for?