Convert Number to Short Time

[SherriKilgore]

How can I convert a number format into a short time format?

For example 0.125 should equal 3am.

 

[plog]

Going off just the one example you've given, this will do it:

TimeValue: DateAdd("n",[YourFieldNameHere]*1440,CDate("12:00 AM"))

 

[Galaxiom]

Time is already stored as a number being the fraction of a day so it is very simple.

Format([field], "medium time")

 

[jdraw]

?Format(0.125 ,"Long time")
3:00:00 AM