Convert time in number of seconds

[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

 

[David Biddulph]

=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.

 

[Heera]

thank u....it worked perfectly....

You gave me good logic.