Convert time in number of seconds
 

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

Convert time in number of seconds
 

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

"Heera" wrote in message
...
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

Convert time in number of seconds
 

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

You gave me good logic.