View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Billy B Billy B is offline
external usenet poster
 
Posts: 54
Default Formattng time question

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