ime Format in Calculation

[Tom Ventouris]

I am using DateAdd("n",-30,[StartTime]) & " for " & [starttime] to insert
8.30am for 9.00am in a report - calculated from the StartTime in a Table. the
result is
8.30.00AM for 9.00.00AM. I need help to get rid of the Seconds.
Thanks in advance.

 

[Arvin Meyer [MVP]]

Try:

Format(DateAdd("n",-30,[StartTime]), "h:nn AM/PM) & " for " &
Format([starttime] , "h:nn AM/PM)