Time format that omits AM/PM

[projecttoday]

I have a Date/time field that contains a value like 5:00 PM. For space problems on a report, it want to print it as "5:00" omitting the PM. I also need to concatenate it to another field so Format(field,"h:mm ampm") and making the textbox short enough so the pm doesn't show really doesn't do what I want. If I use Format(field,"h:mm") 5:00 PM shows as 17:00. If there any way to format a time so it shows the time without am or pm but shows the 12-hour value, not the 24-hour value?

 

[SkipVought]

Hi,

What? 5:00 is not 5PM! Your request is like wanting 4 to be displayed as 2. How will anyone know exactly what 5:00 REALLY means? AM or PM???

But if you insist on this insanity, convert the time to string, using the Format function and then strip the two right characters.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[projecttoday]

How do I do that?

 

[SkipVought]

    MsgBox Left(Format(TimeSerial(17, 0, 0), "hh:mm AM/PM"), Len(Format(TimeSerial(17, 0, 0), "hh:mm AM/PM")) - 3)

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[projecttoday]

Thank you.

 

[SkipVought]

just out of curiosity, when you stated, "I also need to concatenate it to another field ..." exactly what value are you displaying along with time?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[projecttoday]

A hyphen and another date.

 

[SkipVought]

"Another" date? Where is the FIRST date?

Please post the entire string that you're putting in this area on the report.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[projecttoday]

Sorry, I meant another time.

 

[SkipVought]

I'm trying to better understand what you are doing, in order to perhaps, make other suggestions. But you seem to not really understand what I am trying to do. If you wish to be difficult, have it your way.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]