inputting stop watch time

[Guest]

I need to set up a database using stop watch times. I am timing equipment
failures and using a stop watch in 100's of seconds. I can't figure out how
to do this in Access so I can use the time to calculate variances and
differences.

 

[JethroUK©]

use a std number field to 2 decimals (whole/fractions of a second)


this can easily be converted hours/minutes is ness


"(e-mail address removed)"

 

[Guest]

Don't confuse time with elapsed time. A datetime field carries a specific
point in time. You will probably want to use a Single field and variables to
work with this.

you can use an input mask and formatting to make it look like you want it.
You can also do a little math.

The idea is to convert hours to minutes and do all your math using minutes.

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George