EXCEL Formula - How To convert Excel Time (HH:MM:SS) To Second.

From Google search... found this link:

http://www.excelfunctions.net/seconds-to-time-excel.html

As times in Excel are simply numerical values, a specified number of seconds can be converted to an equivalent time value through simple arithmetic.

The decimal value representing 1 second in Excel is calculated as follows:

1 second = 1 / 86400

I.e. 1 second = 1 divided by the number of seconds in a day.

Example below:

Ref: http://www.excelfunctions.net/seconds-to-time-excel.html

Brs,
AZH