# convert h:mm:ss to seconds only

#### allanon1

##### New Member
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 ### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### kgkev

##### Well-known Member
Multiply by 86400 (24x60x60) and display as a number.
Excel Workbook
AB
101:02:003,720.00
Sheet1
Excel 2000
Cell Formulas
RangeFormula
B1=A1*24*60*60

#### VoG

##### Legend
Try

=A1*86400

and format as Number.

#### JugglerJAF

##### Active Member
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

##### New Member
thanks guys that works great

1,106,672
Messages
5,512,798
Members
408,914
Latest member
ariannem