Hello, I have EXCEL cells in the format hh:mm:ss, how do I convert these cells into seconds? Thank you in advance

conversion Excel hh:mm:ss to seconds : CCM

Réponse 1 / 6

Smart91 Posted messages 30146 Status Contributeur sécurité 2 331

=HOUR(A1)*3600+MINUTE(A1)*60 +SECOND(A1)

Smart
--
"If you have no ambitions, you settle on the edge of the abyss" (Kundera)

BlueMind Posted messages 583 Status Membre 159

Hi,

Well done, I messed up a bit on the formula myself :-) No wonder we get old so quickly!

--
Always aim for the moon; in the worst case, you’ll reach the stars;-)

Fanny

Great tip! Thank you very much!

Réponse 2 / 6

adexstirpendam

In fact, this format corresponds to a display for a 24-hour day.
So to convert to seconds, you need to create a new column and choose the normal format, then multiply by 86400.
B1=A1*86400

Réponse 3 / 6

Ivan-hoe Posted messages 433 Registration date Status Membre Last intervention 309

or very simply
=A1*24*60*60
I.

guy311

Fantastic, thanks again to everyone for your help and have a great weekend
(I'll set the computer aside for a restful weekend)

BlueMind Posted messages 583 Status Membre 159

Oh well, sorry, but it's not about the number of hours in A1, so I don't think it will work.

--
Always aim for the moon; in the worst case, you'll land among the stars ;-)

guy311 > BlueMind Posted messages 583 Status Membre

I'm sorry, I tried the formula
=HOUR(N3)*3600+MINUTE(N3)*60 +SECOND(N3)
but it didn't work, in N4 I get 00:00:00
in N3 I have 08:57:14.

Xei Posted messages 158 Status Membre 56 > guy311

Have you tried instead of putting hour minute and second to put hour minute and second? In English it's not bad sometimes ^^ Let us know if it works better ^^

Smart91 Posted messages 30146 Status Contributeur sécurité 2 331 > guy311

The N4 format must be an integer and not a time
--
"If you have no ambitions, you settle on the edge of the fall" (Kundera)

Réponse 4 / 6

Ivan-hoe Posted messages 433 Registration date Status Membre Last intervention 309

Smart91 is right: by default, N4 is set to time format; it needs to be switched back to full or standard!

guy311

Well, this time it's good, I hadn't said that the N4 format was a number
I find 32234 just fine
It's perfect
Thanks everyone

Réponse 5 / 6

Xei Posted messages 158 Status Membre 56

Hello,

By using a simple formula like: if you have hh:mm:ss.
[(((hh*60)+mm)*60) + ss] = your time in seconds, I think that's it, try it and let me know.

guy311

Yes, thank you for the formula, but I misspoke. For example, in cell A1 I have 03:52:14
I would like to find a formula in cell A2 like (A1 * ???)
Thank you for your help.

BlueMind Posted messages 583 Status Membre 159 > guy311

As I told you in my first response, use A2 = 24 * (HOUR(A1)) + 60 * (MINUTE(A1)) + 60 * (SECOND(A1))

--
Always aim for the moon; in the worst case, you will reach the stars;-)

zac

To get the result in seconds, I would say A2 = 3600*(HOUR(A1)) + 60*(MINUTE(A1)) + (SECOND(A1))

Réponse 6 / 6

BlueMind Posted messages 583 Status Membre 159

Hello,

To apply Xei's formula, you need to use the HOUR, MINUTE, and SECOND functions on your TIME format to retrieve the number of hours, minutes, and seconds, respectively.

Good work.

--
Always aim for the moon; even if you miss it, you will land among the stars. ;-)

Conversion Excel hh:mm:ss to seconds

6 réponses

Samsung j5 unable to answer

Scam of the suvedene highway

Minecraft restore the cursor and the bar.

My ps3 keeps shutting down on its own...

Samsung series 4 led tv logo display...

How to enable bluetooth on a samsung tv?

Ctrl key issue

[metin2] sura ...

Freebox tv locked step 2 or network

Error 46 (brother dcp-150c) cleaning impossible