How do I get the result of the query in "short time" format?

[Guest]

I am trying to build a simple query that subtracts "start time" from "end
time" to give me a "total time" this is a piece of cake to do if you have
numbers. But I need this to be in a "time" format. All Access gives me as a
result is a small number (like 0.0358) instead of a time in HH:MM format.
What do I need to do to get the result of the query in short time format?

 

[Douglas J Steele]

Try setting the Format for the field.

Internally, Access represents date/time values as 8 byte floating-point
numbers, where the integer portion represents the date as the number of days
relative to 30 Dec, 1899, and the decimal portion represents the time as a
fraction of a day.

On the other hand, the Date data type is only intended to represent a
timestamp (i.e: a specific date and time).. You probably should using the
DateDiff function to determine the total number of seconds between the two
times.

 

[Guest]

Hi Julie,

Try this article:
On time and how much has elapsed
http://office.microsoft.com/en-us/assistance/HA011102181033.aspx


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

I am trying to build a simple query that subtracts "start time" from "end
time" to give me a "total time" this is a piece of cake to do if you have
numbers. But I need this to be in a "time" format. All Access gives me as a
result is a small number (like 0.0358) instead of a time in HH:MM format.
What do I need to do to get the result of the query in short time format?