time format
 

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

time format
 

Custom format as: m:ss


--
Regards
Dave Hawley
www.ozgrid.com
"818jaime" wrote in message
...
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

time format
 

On May 6, 8:18*pm, "ozgrid.com" wrote:
Custom format as: m:ss

--
Regards
Dave Hawleywww.ozgrid.com"818jaime" wrote in message

...



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- Hide quoted text -

- Show quoted text -

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?

time format
 

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
"818jaime" wrote in message
...
On May 6, 8:18 pm, "ozgrid.com" wrote:
Custom format as: m:ss

--
Regards
Dave Hawleywww.ozgrid.com"818jaime" wrote in message

...



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- Hide quoted text -

- Show quoted text -

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?

time format
 

On May 6, 8:45*pm, "ozgrid.com" wrote:
It must been seen as Text. Copy any empty cell, select you text times and
paste special - values - add - OK.

--
Regards
Dave Hawleywww.ozgrid.com"818jaime" wrote in message

...
On May 6, 8:18 pm, "ozgrid.com" wrote:





Custom format as: m:ss

--
Regards
Dave Hawleywww.ozgrid.com"818jaime" wrote in message

....

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- Hide quoted text -

- Show quoted text -

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 -

That worked, Thank you!