DorisH3 at aol.com
DorisH3 at aol.com
Tue Dec 5 11:03:27 CST 2006
Hi GK,
Yes, my TimeIn and TimeOut fields are Date/Time fields....I also need to
show the minutes along with the hours. The DateDiff function did not work....I
set it up this way in my query...Hours:DateDiff("h", [TimeOut], [TimeIn})
then I reversed the TimeOut and TimeIn fields and that showed a minus in front
of the number.....what I am wondering if I could do a function that would
convert everything over 24 hrs from days to hours and minutes by multiplying by
1440(24 x 60)....what do you think?
Doris