time converting

[818jaime]

Hello
I need help.
I'm exporting from avaya IQ example I'm exporting a report and it is
average wait duration is in "00:00:12"
I need to conver that which is probably in text I'm asuming to just
pain 12
another example 00:01:09 I need that converted to 69 and so on
Please help..

 

[Rick Rothstein]

You can use the following formula to convert your values. Assuming your
value is in A1...

=A1*86400

 

[818jaime]

You can use the following formula to convert your values. Assuming your
value is in A1...

=A1*86400

--
Rick Rothstein (MVP - Excel)






- Show quoted text -

Thank you!

 

[joeu2004]

You can use the following formula to convert your values.
Assuming your value is in A1...
=A1*86400

As always, it is best to explicitly round results of arithmetic
operations involving numbers with decimal fractions.

For example, if A1 is "0:00:11" and A2 is simply =A1*86400, then
=(A2-11=0) is FALSE(!) instead of TRUE, and =LOOKUP(A2,{0,11},{1,2})
returns 1(!) instead of 2.

All is well if A2 is =ROUND(A1*86400,0).