Hi ALE77 - This may help...to convert military time 13.89475 to standard time, follow these steps:

1. Separate the hours and the decimal part:
   • Hours: 13
   • Decimal part: 0.89475
2. Convert the hours:
   • 13 hours in military time is 1 PM in standard time.
3. Convert the decimal part to minutes and seconds:
   • Multiply 0.89475 by 60 to get the minutes: 0.89475 * 60 ≈ 53.685 minutes.
   • Separate the minutes and the decimal part: 53 minutes and 0.685 minutes.
   • Convert the remaining decimal part to seconds: 0.685 * 60 ≈ 41.1 seconds.

So, 13.89475 in military time converts to approximately 1:53:41 PM in standard time.

In SQL:

In Crystal Reports:

TimeValue(ToNumber({CI_Item.TimeCreated})/24)

Thank you, that worked great!

thank you!

Be careful with methods that separate the hour calculation from the minute calculation.

E.g. 13.99, rounded to the minute, will translate to 1:00 PM instead of 2:00 PM, unless you specifically add logic to handle the minutes rounding "up" to :00.