View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cheri Cheri is offline
external usenet poster
 
Posts: 53
Default Formula to Change Hours:Minutes:Seconds to Seconds only

I am looking for a formula to change the hours:minutes:seconds to seconds
only. So, if I have 90:18:13 in cell A1, I want it to return 325093 in cell
B1 without my having to separate the entry into three cells with a formula to
add the seconds together.

Thanks for your help!
Cheri