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

  • Thread starter Thread starter Guest
  • Start date Start date
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

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

tsp <[email protected]> wrote:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert time expressed as a decimal to actual hours or minu 8
how do i convert data with miliseconds to just h:mm:ss 5
h:mm:ss formula 4
Converting Total Time hh.hh to HH:MM:SS 5
Converting minutes & seconds to total seconds 3
Calc minutes and seconds difference 15
Selecting business hours via date / if function? 2
Formula Cell Format -Change H:MM:SS to Currency 2

Back
Top