Thanks for the suggestion. That is awesome...and easy!!!
Thanks again,
Cheri
"Peo Sjoblom" wrote:
Format as general and multiply with 86400 (24*60*60)
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)
"Cheri" wrote in message
...
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