I have a field (lbstdate) where i enter date and time - ex 03/20/2009 10:00 AM
I then enter end date and time (lbeddate) - ex 03/20/2009 11:30 AM
With this Me.LbNomHour = DateDiff("h", [LbStDate], [LbEdDate]) I get 1.0 and i lost the half hour.
with this Me.LbNomHour = DateDiff("n", [LbStDate], [LbEdDate]) I get 90.0 which means i have the half hour.
What i want to see is 1.5
How do i make that happen??
Thanks in advance for any thoughts you might have.