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
