convert h:mm:ss to seconds only

[allanon1]

how to convert hours:minutes:seconds to just seconds. for example in cell a1 I have 1:02:00 would come out 3720. any formula to do so would be great thanks

 

[kgkev]

Multiply by 86400 (24x60x60) and display as a number.

Excel Workbook
	A	B
1	01:02:00	3,720.00
Sheet1

Excel 2000

Cell Formulas
Range	Formula
B1	=A1*24*60*60

 

[VoG]

Try

=A1*86400

and format as Number.

 

[JugglerJAF]

Depending on how precise you want the numbers, you may want to round the calculation to zero decimal places

=ROUND(A2*86400,0)

Excel does very precise calculations, but multiplying a time value by 86400 can (for some values) result in a decimal being calculated rather than a whole number of seconds.

For example, 02:10:25 when multiplied by 86400 returns 7824.99999999995. If you were to compare the calculation to a value of 7825 (the actual number of whole seconds in 02:10:25), the two would not match. Rounding the calculation to zero decimal places resolves the issue.

 

[allanon1]

thanks guys that works great