|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 7th, 2010, 02:11 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
May 7th, 2010, 02:18 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
May 7th, 2010, 02:41 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
|
#4
May 7th, 2010, 02:45 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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?
|
|
#5
May 7th, 2010, 04:23 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
