time converting

  • Thread starter Thread starter 818jaime
  • Start date Start date
8

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..
 
You can use the following formula to convert your values. Assuming your
value is in A1...

=A1*86400
 
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 -
Click to expand...

Thank you!
 
You can use the following formula to convert your values.
Assuming your value is in A1...
=A1*86400
Click to expand...

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).
 
Back
Top