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
 
Set the Format property of the text box on the report to:
hh\:nn
 
Allen said:
Set the Format property of the text box on the report to:
hh\:nn

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top