Time as 24hrs in report

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a report where time is expressed in 24hr format.

It is imperative that 07:00 is expressed that way.

Currently if I choose "Short Time" in properties the time is shown as
7:30 which could be confused by some as being an evening time.

How do I display it as 07:30 ??

Thanks,

Robin Chapple
 
Allen said:
Set the Format property of the text box on the report to:
hh\:nn
Click to expand...

Actually I have never been able to get the format "Property" to display
leading zeros in the hour. The Format() function will do it, but the
property always drops the leading zero on the hour.
 
Rick,

The hh\:nn would not work for me either.

I had success with the format function though.

Thanks,

Robin
 
Back
Top