Time Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a numeric expression that I would like to convert to Time format
(military time displayed as a number).
MY Number = 160016 needs to convert to 4:00:16 PM
MY Number = 23747 needs to convert to 2:37:47 AM
MY Number = 115758 needs to convert to 11:57:58 AM

Thanks in advance
 
henryriver said:
I have a numeric expression that I would like to convert to Time
format (military time displayed as a number).
MY Number = 160016 needs to convert to 4:00:16 PM
MY Number = 23747 needs to convert to 2:37:47 AM
MY Number = 115758 needs to convert to 11:57:58 AM

Thanks in advance
Click to expand...

TimeValue(Format([YourField],"00:00:00"))
 
Thanks, I think it worked from home, but I'll try at work tomorrow. Where
can a person find these format types in the future? You make it look easy.

Rick Brandt said:
henryriver said:
I have a numeric expression that I would like to convert to Time
format (military time displayed as a number).
MY Number = 160016 needs to convert to 4:00:16 PM
MY Number = 23747 needs to convert to 2:37:47 AM
MY Number = 115758 needs to convert to 11:57:58 AM

Thanks in advance
Click to expand...

TimeValue(Format([YourField],"00:00:00"))
Click to expand...
 
henryriver said:
Thanks, I think it worked from home, but I'll try at work tomorrow.
Where can a person find these format types in the future? You make
it look easy.
Click to expand...

Try the help topics...

User-Defined DateTime formats (Format function)

User-Defined Numeric formats (Format function)

User-Defined String formats (Format function)
 
Back
Top