MrExcel Publishing
Your One Stop for Excel Tips & Solutions

TIME Conversion


Posted by Ken Aldag on February 01, 2001 10:16 AM

I have some values of time in a column of :59, 1:32, 2:09 and want to convert those values to seconds. Do I have to convert to the serial number and then to seconds???

Ken


Posted by Mark W. on February 01, 2001 2:40 PM

Ken, does the [ss] format do what you want? Or
would you like to convert the date value to an
integer using:

=TEXT(datevalue,"[ss]")+0