converting time to 24-hour clock

building reports desktopintelligence
1

I inherited a report using a stored procedure as a data provider. There are two dates which are returned in the format “mm/dd/yyyy hh”, but the time is in 12-hour format. I need to change that to 24-hour format. I tried the “mm/dd/yyyy hh” format cell to no avail.

Any suggestions would be greatly appreciated.

Thanks,
Michael

Listserv Archives (BOB member since 2002-06-25)

2

I need to change that to 24-hour format. I
tried the “mm/dd/yyyy hh” format cell to no avail.

Try using capital H instead of a lower case h

i.e. “mm/dd/yyyy HH”

Regards

Rich Harris
CMS Team - Telewest Woking
Tel 01483 251597

Listserv Archives (BOB member since 2002-06-25)

3

Thanks,

I guess my eyes are getting old!

Regards,
Michael

Listserv Archives (BOB member since 2002-06-25)