Convert Date/time to text?

A

AndyB

I have a field that is using a military time format. 23:15 for example. I
want to convert the values to text so it can interact better with programs
like MAPINFO. When I attempt to convert them I usually get 1's or
12/30/1899. I would like it to be 2315 in text format?


Andy B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert text to date 2
Windows 7 I need to convert date to text 3
Peculiar default cell format 1
change data type from text to date/time 1
Expressions in a form 2
Convert Time to Text 2
Excel Convert Datetime Stamp to HH and MM Worked 7
Format Date in Report 1

Top