Time format

  • Thread starter Thread starter Shirley
  • Start date Start date
S

Shirley

I need to export a table to Excel. The table has a field -
- CallTime--with time format. When I exported this table
to Excel, everything else is cool except the time format
is changed.

If I created a form on this table first, and then export
the form to excel, the time format will be keeped. But
this process is too much trouble especially when I want
to create some tables on the fly.

So how can I keep the time format in exproted file?

Thanks,

Shirley
 
Wrap the time field with the Format function and tell it the specific format
to be used:

NewTimeFormatField: Format([TimeField], "hh:nn")
 
Back
Top