Anyone know how to convert a time (format= HH:MM:SS) into seconds? example: 1:10:05 = 4205
A Arturo Jan 18, 2005 #1 Anyone know how to convert a time (format= HH:MM:SS) into seconds? example: 1:10:05 = 4205
J JE McGimpsey Jan 18, 2005 #2 XL stores times as fractional days, so you need to multiply the time by 24*60*60, or =A1 * 86400
