Formatting time: eliminate additional :00

  • Thread starter Thread starter Claudia in DC
  • Start date Start date
C

Claudia in DC

I would like to include a time and date together (not the current one, but
from the database).

When I use:
=([Date]) & ", " & ([Time])

I get:
4/30/2009, 9:15:00 AM

How can I get rid of the last :00?
 
=Format([Date] + [Time], "m/d/yyyy \, h:nn")

Incidentally, if those are your real field names, change them. Date and TIme
are both reserved words, and should never be used for your own purposes. For
a comprehensive list of names to avoid (as well as a link to a free utility
to check your application for compliance), check what Allen Browne has at
http://www.allenbrowne.com/AppIssueBadWord.html
 
Back
Top