Conversion Excel hh:mm:ss to seconds

Solved/Closed
guy311 -  
 flaw -
Hello,

I have EXCEL cells in the format hh:mm:ss, how do I convert these cells into seconds?
Thank you in advance
Configuration: Windows 2000 Internet Explorer 6.0

6 réponses

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)
52
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;-)
0
Fanny
 
Great tip! Thank you very much!
0