Time to show in normal format?

[allen_jr]

Hi, I am trying to create a report that will show employee shift time... I have a query that pulls a "Start Time" and "End Time", which are both in Medium Time (6:00AM)

In my report, I have the following concatenation:
=[Start Time]&" - "&[End Time]

Which I want to show:
6:00AM - 5:00PM

But, what it shows is:
6:00:00AM - 5:00:00PM

I have tried changing the format in the Property Sheet to Medium Time, and even tried Short Time, but the results in the report won't change...

I am also using the following equation, in a separate expression in my query:
ShiftHours: Format([Start Time]-1-[End Time],"Short Time")

This allows me to place the length - in hours - of each "shift", which I am publishing in my report... the result form this looks like:
11:00, or 04:00 (depending on shirt length obviously)
This equation works great, just providing the info in case anyone finds it relevant...


Any one have any ideas? Thanks so much for any help!

 

[boblarson]

Format each part:

=Format([Start Time], "Short Time") & " - " & Format([End Time], "Short Time")

 

[allen_jr]

So awesome!!!! Thanks!!!!!

 

[allen_jr]

OK... got the time showing better... does anyone know if there is a way to keep track of their "running total" of hours... As I mentioned earlier, the hours per shift are calculated in the query, and each person gets those hours/shift

Is there a way to keep a tally of their hours over the weekend?>

FYI .. this is for a tradeshow event we produce annually, so we are just trying to track their hours over the 4 days... thanks!