Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-16-2010, 12:19 PM
FraserKitchell FraserKitchell is offline Time as text conversion problems Windows XP Time as text conversion problems Office 2007
Novice
Time as text conversion problems
 
Join Date: Dec 2009
Posts: 21
FraserKitchell is on a distinguished road
Default Time as text conversion problems

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
Reply With Quote
 

Tags
text, time



Similar Threads
Thread Thread Starter Forum Replies Last Post
Anyway to determine time/date of text creation? pureride Word 1 01-05-2010 02:09 PM
Time as text conversion problems Measurement Conversion Tables 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
Time as text conversion problems Auto Shape Conversion Launchnet Excel 1 04-18-2006 06:25 AM
Time as text conversion problems Specific Lat Long Conversion Help chesspupil Excel 2 04-16-2006 11:06 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft