Solved

Time format with fraction of seconds

Posted on 2002-05-09
5
201 Views
Last Modified: 2012-06-27
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
Comment
Question by:MFrey
5 Comments
 
LVL 1

Expert Comment

by:dougp23
ID: 6998752
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
 

Author Comment

by:MFrey
ID: 6998762
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
 
LVL 54

Expert Comment

by:nico5038
ID: 6998805
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
 
LVL 54

Expert Comment

by:nico5038
ID: 7220043

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
 

Accepted Solution

by:
Jgould earned 0 total points
ID: 7240231
Question has been moved to PAQ and points not refunded as per recommendation

JGould-EE Moderator
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question