Time subtract in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 fields ' received ' and ' ready ' recording the time of an action in
short date format

I want to calculate the time between the 2

Prep Time: [received]-[read]

Table holding data 09:00 and 10:00 in fields respectively
It give an answer 0.0416666666.....

I was hoping to see 60 mins How can I do this?
 
Martyn

Access stores date/time data as a decimal. The integer portion is the
number of days since some date in the late 1800s. The decimal portion is
the portion of 24 hours -- a decimal value of .5 would be "noon".

If you want minutes, you have to multiply times the number of minutes in 24
hours (i.e., 24 * 60).
 
yes thanks I found answer by time you came back by examining some data and
punching in some ideas into a calculator

ta anyway

Jeff Boyce said:
Martyn

Access stores date/time data as a decimal. The integer portion is the
number of days since some date in the late 1800s. The decimal portion is
the portion of 24 hours -- a decimal value of .5 would be "noon".

If you want minutes, you have to multiply times the number of minutes in 24
hours (i.e., 24 * 60).

--
Good luck

Jeff Boyce
<Access MVP>

martyn said:
I have 2 fields ' received ' and ' ready ' recording the time of an action in
short date format

I want to calculate the time between the 2

Prep Time: [received]-[read]

Table holding data 09:00 and 10:00 in fields respectively
It give an answer 0.0416666666.....

I was hoping to see 60 mins How can I do this?
Click to expand...
Click to expand...
 
Back
Top