Formula to Change Hours:Minutes:Seconds to Seconds only
Thanks Franz! I appreciate your help very much!!!
Cheri
"Franz Verga" wrote:
Cheri wrote:
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
Hi Cheri,
Use this in B1:
=A1*24*3600
You have to format B1 as General or as Number.
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|