Thread: Convert time in number of seconds
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Heera Heera is offline
external usenet poster
  
Posts: 98
Default 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
Reply With QuoteReply With Quote