Re: Convert hh:mm:ss to seconds
Excel stores dates and times as numbers, with the integers representing days (since 1 january 1900). The decimal part is the fraction of a day.
If your cell has only hh:mm:ss with no day part, (Excel will treat it as that time on 1 January 1900), simply multiply the cell by the number of seconds in a day -- 24*60*60)
EDIT: If your cell might also have a non-zero date component, just to be safe you could use:
where A1 is assumed to have your orginal hh:mm:ss data.
Last edited by thomach; May 16th, 2005 at 22:54.
Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.