Formattng time question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am updating an excel worksheet from a query in Access. One of the fields in
the database is time and the query works. The excel field is formatted as
time and displays 2:00 PM or 14:00 depending on the format. What I need to do
is have the cell display 2:00. Is that possible? and if so, how?

Thank You
 
Back
Top