Convert time in number of seconds

  • Thread starter Thread starter Heera
  • Start date Start date
H

Heera

Hi,

How can a convert the time into number of seconds.

For Eg

12:30:45 = 45045

Does any one know the formula. I have writen a macro for it but if
there is a formula it will be helpful.

Regards
Heera
 
=A2*24*60*60
or =A2*86400
and format as general or number.

Excel stores time in days, and there are 24 hours in a day, 60 minutes in an
hour, & 60 seconds in a minute.
 
Back
Top