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

=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