time format

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

818jaime

Can some one please tell me how to format time exported from Avaya IQ.
example time exported 00:01:23
I need to format to only read 1:23 in excel 2007.

Thank you
 
Custom format as: m:ss

--
Regards






- Show quoted text -
Click to expand...

It does not work. That only works if you manually type in the 00:01:23
in excel but when I copy and paste an export from IQ it just sees it
as a plain number 00:01:23 and will not changed it to m:ss any more
suggestions?
 
It must been seen as Text. Copy any empty cell, select you text times and
paste special - values - add - OK.



--
Regards
Dave Hawley
www.ozgrid.com
Custom format as: m:ss

--
Regards






- Show quoted text -
Click to expand...

It does not work. That only works if you manually type in the 00:01:23
in excel but when I copy and paste an export from IQ it just sees it
as a plain number 00:01:23 and will not changed it to m:ss any more
suggestions?
 
It must been seen as Text. Copy any empty cell, select you text times and
paste special - values - add - OK.

--
Regards





It does not work. That only works if you manually type in the 00:01:23
in excel but when I copy and paste an export from IQ it just sees it
as a plain number 00:01:23 and will not changed it to m:ss  any more
suggestions?- Hide quoted text -

- Show quoted text -
Click to expand...

That worked, Thank you!
 
Back
Top