| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
| Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions | |||
Linear Mode
