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

Formula to Change Hours:Minutes:Seconds to Seconds only
 

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

Formula to Change Hours:Minutes:Seconds to Seconds only
 

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

Formula to Change Hours:Minutes:Seconds to Seconds only
 

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

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