Converting already entered time from 12hr to 24hr format

A

AGOKP4

Hi all,

Is it possible to convert already entered times in a12hour format to a 24
hour format? e.g I'd like times like 1.00PM to show 13.00PM

THANKS!
 
A

anlu

Assuming that your time is of datatype date/time, you can use the Format
function with the "hh:nn" format. (Using 24 hour format, you don't need the
PM indication).

Regards,
anlu
 
J

John W. Vinson

Hi all,

Is it possible to convert already entered times in a12hour format to a 24
hour format? e.g I'd like times like 1.00PM to show 13.00PM

THANKS!
Click to expand...

A Date/TIme field isn't stored with ANY format - it's actually a double float
number, a count of days and fractions of a day (times) since midnight,
December 30, 1899.

Just change the Format property of the field to "hh\.nn" to show 1:00pm as
13.00.
 
Top