Converting already entered time from 12hr to 24hr format

  • Thread starter Thread starter AGOKP4
  • Start date Start date
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!
 
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
 
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.
 
Back
Top