![]() |
#1
|
|||
|
|||
![]()
Hi there,
I am having difficulty converting a time text string to a time format. Currently the time stamp is as follows: 2/8/10 11:00:00 AM PST 2/8/10 11:05:00 AM PST I would like the data to be in two columns, the first a date only 2/8/10 and the second a full timestamp 11:00:00 AM (formatted for time, further functions to be driven off this time) Problem is I cant make a few things happen: 1) data to columns with a space delimiter is great, but I cannot get the AM back into the formula and get to a correct timestamp. 2) I am unable to us a replace, concatentate, && type formulas it seems, Although promising, I also cant figure out a timevalue, etc type formula. Let me know if you can think of something to work, happy solving, Fraser |
Tags |
text, time |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Anyway to determine time/date of text creation? | pureride | Word | 1 | 01-05-2010 02:09 PM |
![]() |
bhalliday | Excel | 1 | 05-10-2009 11:20 PM |
Set text in edit control on inspector window indicating time Outlook 2007 | saniltalathi | Outlook | 0 | 02-20-2009 08:43 AM |
![]() |
Launchnet | Excel | 1 | 04-18-2006 06:25 AM |
![]() |
chesspupil | Excel | 2 | 04-16-2006 11:06 PM |