After all, 1 is a whole day = 24 hours, so 5/24 is 5 hours. Dates and times ARE numbers in MS Office, and only FORMATTED as dates.
If you really can't get it working, write a small VBA-function with the time difference as one of the parameters. Using elementary debugging, you'll find out what to write exactly. But I don't think it's necessary.
I have a query in access where I'm trying to put in a calculated field that is an Iif function. One field in the query is "Time In" which is set to a Time Format, another field is "Time Out" which is also set to a Time Format. It is basically a time log such as time in is 8:00 a.m and time out would be say 12:30 p.m.
I then have a calculated field in the query that shows how much time elapsed between the two such as - and it is formatted to SHORT TIME so it shows 4:30 based on the example above.
Now I want to make another field that based on the Iif function something like if the hours elapsed is over 5 put YES otherwise put NO if it's false..........but my problem is that I cannot get the condition over 5 so that access sees it as a short time format.
I have tried >5:00
I have tried >5
but it doesn't see it as a short time format giving me all the false returns.....I have even tried putting it enclosed in the # symbols but that only takes it as 5:00 am.....SO MY QUESTION IS, DOES ANYONE KNOW HOW TO DO THE IIF FUNCTION AND HAVE A FIELD REFERENCED IN THE CODITION BUT TO HAVE ACCESS TAKE IT AS A SHORT TIME FORMAT