Calculate time

[gmazza76]

Good afternoon,

I have created a query that calculates time, but it doesnt appear correct I think.

In my source table ([time]) I am calculating the time spent that has been registered for jobs completed in a day, which seems to work but my times calculated together show as "5.71759259259259E-03".

How would I get the query to show these as 00:00:00 for the day?

thanks in advance

 

[plog]

Here's a thread that can help with the format:

format time to [hh]:mm in a query

Hello, I would like to format the time to read as [hh]:mm in my query Note *** I already have a "does not equal" value in the same query on the same colunm/field How do I do this? Thank you in advance

www.access-programmers.co.uk

However 5.71E-03 is equivalent to about .00571. You didn't provide units or how you did the calculation so I don't know if that is correct or not.
Does that number sound correct? If not, you need to work on the calculation as well.

 

[arnelgp]

you google DateDiff() function, so you can provide "unit" when calculating difference:
if you want to get difference in seconds:

=DateDiff("s",[TimeIn], [TimeOut])

 

[The_Doc_Man]

First, 5.71E-03 is about 8.22 minutes. When you work with dates, you should know that they are in units of DAYS, so that is merely a small fraction of a day. If you fed that time to a FORMAT function with a time-based format choice, it would probably respond with 00:08:13 (approximately). When you directly subtract one date field from another (which technically IS valid), you get a difference in days and fractions of a day in DOUBLE format.

 

[Pat Hartman]

Here's a database with some useful date functions.

Sample Date Functions

This database contains a number of date functions that you can simply copy into your application. There is a tabbed form to show you how to use the calculations. A partial list of functions is: Business days between two dates. Business day + days = next business date Easter (Western) Age...

www.access-programmers.co.uk