fraction of a second

Angus

can anyone tell me how to get a format to show seconds to 1 decimal place?
I can get a format in excel to show hh:mm:ss.0 but I cannot seem to get it
in access. Any help would be greatly appreciated

Thanks
Angus

Nov 12 '05 #1

Subscribe Post Reply

3752

Rick Brandt

"Angus" <an********@onetel.net.uk> wrote in message
news:3f******@212.67.96.135...

can anyone tell me how to get a format to show seconds to 1 decimal place? I can get a format in excel to show hh:mm:ss.0 but I cannot seem to get it in access. Any help would be greatly appreciated

Access (Jet) only resolves DateTime to a resolution of one second. You
would have to store finer precision than that in a text field and work out
a way to do the math against them yourself.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 12 '05 #2

Peter De Baets

Angus,

We've developed a set of functions that can be used to manipulate time
values below the level of a second. The free module is available here:
http://www.peterssoftware.com/ctf.zip

Hope this helps,
--
Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com

"Angus" <an********@onetel.net.uk> wrote in message
news:3f******@212.67.96.135...

can anyone tell me how to get a format to show seconds to 1 decimal place?
I can get a format in excel to show hh:mm:ss.0 but I cannot seem to get it
in access. Any help would be greatly appreciated

Thanks
Angus

Nov 12 '05 #3

by: John Cho | last post by:

// CHO, JOHN #include<iostream> class fracpri{ int whole; int numer; int denom;

C / C++

Converting fraction to time

by: M. Uppal | last post by:

How do i convert fraction to time in c#. I need to convert 0.25 to time. Excel does this by using Selection.NumberFormat = "h:mm:ss;@" of the Cell Format function. thanks, M. Uppal

C# / C Sharp

Help with Fraction Project

by: amarok | last post by:

Hello all. I'm a Software Engineering student, and I'm attempting to write a program in Java that does as follows: UML for the class: Fraction() Fraction(numerator: int) ...

Java

Help getting user input into my fraction calculating program.

by: evilmonkey | last post by:

I am very new to programming as well as Java and this is my first post so please forgive me if this is not quite posted correctly. My Problem is that I have only been using scanner to get user input...

Java

Fraction Program Error

by: d0ugg | last post by:

Hi, I'm did a fraction program for one of my programming classes and it did compile, however when I'm running the program it crashes for some reason that I do not know. // fraction.cpp ...

C / C++

Fraction program

by: d0ugg | last post by:

Hi, I'm doing a FRACTION program for one of my Programming classes and I'm getting some errors that I can't figure it out. Here is the Assignment: 1. Convert the fraction structure into a...

C / C++

Functions In Fraction Calculator

by: Nkhosinathie | last post by:

hello everyone,i'm writing this csalculator proogram that is using functions to perform functions in a fraction calculator.this is what i did and my problem now the readInFraction does not take the...

C / C++

Fraction Program - Reducing it to the lowest terms

by: d0ugg | last post by:

Hello everyone, I'm creating a program that it is suppose to add, subtract, multiply and also divide fractions and after that, the result has to be reduced to the lowest terms. However, I'm not...

C / C++

Fraction Calculator Problem

by: Stolas | last post by:

Hello all, I'm attempting to create a Fraction Calculator. But for some reasons on my RationalTest program it is giving me an error that getAdd in Rational cannot be applied to (Rational). I'm very...

Java

C++ Fraction progra using classes-Help

by: jrw133 | last post by:

So i was given this program in class. i am supposed to create a four-function calculator for fractions using a fraction class. Heres what the requirements are:create a member function for each of...

C / C++

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Similar topics