ime Format in Calculation

  • Thread starter Thread starter Tom Ventouris
  • Start date Start date
T

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.
 
Try:

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