Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Military Time
Message
From
01/08/2007 15:52:52
 
 
To
01/08/2007 15:37:55
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01245247
Message ID:
01245254
Views:
17
>How can I convert the following to non-military time? And yes, before the jokes start, the "13:45" is a value in an array. I can't just retype it to "1:45" instead. Thanks!
>
>
>(RIGHT( "0" + ALLTRIM( "13:45" ), 5 ))
>
Hilmar and Naomi gave you the correct answer, but if you just need a quick and dirty solution and your system is set to 12 hour time you can do this:

RIGHT(TTOC(CTOT("13:45")),11)

It gets 00:00 correctly but not 24:00
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform