Time Format

[Nuno Borges]

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

 

[Jeff Boyce]

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]

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

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>

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