How to convert Minutes and Seconds to just Seconds in Excel

To convert a time (hh:mm:ss) in Excel

Option 1:

To convert a time (hh:mm:ss) in Excel, it may be easiest to multiply the cell by 86,400 which is the number of seconds in a 24 hour period.

eg:  2:15:05 would become 8,105
and 0:01:05 would become 65.

Option 2:

Change the cell format from the time format to this custom format [s].0

Option 3

Another option is to use the MINUTE and SECOND functions.

eg: =MINUTE(A1)*60+SECOND(A1)

This will convert time such as 2:15:05 in cell A1, to the total value in seconds.

1,158.1 - 604,733
Scroll down for Comments
0 0 votes
Article Rating
Notify of

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Inline Feedbacks
View all comments