Google sheets duration to seconds

To convert duration to an integer expressing the number of seconds, use a formula such as

=value(A1*24*3600)

Time values are recorded so that 1 is one day. Multiplying by 24 (hours/day) and 3600 (seconds/hour) converts that to seconds. Then value makes it a number rather than duration.


Old answer, about formatting only.

You don’t need any formulas to format duration as the number of seconds.

  1. Go to Format > Number > More formats > More data and time formats
  2. Delete the pre-filled format fields and add “Elapsed seconds” from the dropdown menu.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)