Time Format

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

Guest

Hi,

My question is about time formats on an Access Table.
I'm using for a race control, an excel spredsheet the format that is
working very fine, but have same limitations.
On the excel i use the format "[h]:mm:ss,000;@", for the field time,

How can i use time controls, like i'm using on Excel, in Access?

Best Regards

Nuno Borges
 
Nuno

Access doesn't have a Time Control, or a Time data type, and the Access
Date/Time field stores a point-in-time, not a duration. Are you asking
about formatting for a duration?

Jeff Boyce
<Access MVP>
 
Thanks for you replai, Jeff Boyce

Yes, i think that is duration, because I pretend to have the diference
between to time values in the format "[h]:mm:ss,000;@", where the "0",
(Zeros) are fractions of a second like that example:

0:08:05,377 - 0:08:04,155 = 0:00:01,222

Best Regards
Nuno Borges



Jeff Boyce said:
Nuno

Access doesn't have a Time Control, or a Time data type, and the Access
Date/Time field stores a point-in-time, not a duration. Are you asking
about formatting for a duration?

Jeff Boyce
<Access MVP>

Nuno Borges said:
Hi,

My question is about time formats on an Access Table.
I'm using for a race control, an excel spredsheet the format that is
working very fine, but have same limitations.
On the excel i use the format "[h]:mm:ss,000;@", for the field time,

How can i use time controls, like i'm using on Excel, in Access?

Best Regards

Nuno Borges
Click to expand...
Click to expand...
 
Back
Top