• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • 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

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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