Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

Time format with fraction of seconds

Hello.

I would like to store the following time (21 minute 22 seconds and 45 hundreth)

I would like to input it like this:   21:22.45

I would also need this value for some calculations (1282.45 s). Can I convert it to seconds and then back to a mm:ss.xx format ?

Thanks

Marcel
0
MFrey
Asked:
MFrey
1 Solution
 
dougp23Commented:
I would think that would you store the initial value (21:22.45) as Short Time.  To get the seconds, just multiply by 60.

0
 
MFreyAuthor Commented:
Not working, I cannot enter the time value 21:22.45 in a field formated as Short Time. It does not accept this value
0
 
nico5038Commented:
I guess you'll need to go and work with fractions, just checkout:
http://www.mvps.org/access/datetime/date0009.htm

(Many other fine samples!)

Nic;o)
0
 
nico5038Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
JgouldCommented:
Question has been moved to PAQ and points not refunded as per recommendation

JGould-EE Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now