ExcelBanter - Is there a formula that will convert h:mm:ss into seconds?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Is there a formula that will convert h:mm:ss into seconds? (https://www.excelbanter.com/excel-worksheet-functions/60249-there-formula-will-convert-h-mm-ss-into-seconds.html)

tsp

Is there a formula that will convert h:mm:ss into seconds?

JE McGimpsey

Is there a formula that will convert h:mm:ss into seconds?

A formula:

Since XL stores times as fractional days, you can multiply by the number
of seconds in a day:

=A1*86400

If you only want to display seconds, you can use

Format/Cells/Number/Custom [s]

(the brackets prevent roll-over to minutes & hours).

In article ,
tsp wrote:

All times are GMT +1. The time now is 09:08 PM.