R
RichG
I have a question concerning the display of a calculated field based on the
DateDiff function.
Assume there exist “Start Time†and “End Time†fields that contain valid
date & time information, and the date and time difference between these two
fields is 75 minutes.
I have created the following queries successfully…
Duration (Min): DateDiff("n",[Start Time],[End Time])
Duration (Hrs): DateDiff("h",[Start Time],[End Time])
The “Duration (Min)†query shows the following result: 75
The “Duration (Hrs)†query shows the following result: 1
I am trying to find a method of displaying the results as 1.25 hours
(decimal equivalent of 1-1/4 hours).
Can anyone offer suggestions as to how this may be accomplished?
I would like to be able to use this method in forms as well as queries.
DateDiff function.
Assume there exist “Start Time†and “End Time†fields that contain valid
date & time information, and the date and time difference between these two
fields is 75 minutes.
I have created the following queries successfully…
Duration (Min): DateDiff("n",[Start Time],[End Time])
Duration (Hrs): DateDiff("h",[Start Time],[End Time])
The “Duration (Min)†query shows the following result: 75
The “Duration (Hrs)†query shows the following result: 1
I am trying to find a method of displaying the results as 1.25 hours
(decimal equivalent of 1-1/4 hours).
Can anyone offer suggestions as to how this may be accomplished?
I would like to be able to use this method in forms as well as queries.