Newbie Access guy....I asked in a pevious post how to calculate time duration so when someone entered 7:00 Am start time and 8:00 am end time Access would know it was 1 hour. The experts told me to use this calc in my query... 24*([EndTime]-[StartTime])
This works great for the AM hours, but for the PM hours it is reporting a LONG number on my report (based on the query) See the attachment, you can see when I put 18:00 to 19:00 it displays 0.99999999 but when I put in 6:00 to 7:00 it shows 1 hour. On the form the user enteres 6A for 6:00 AM or 3P for 3:00 PM. The forms displays the duration corectly too, but on the AM ones if I click in the duration field (for 9A - 10A) it stays a 1, but if I click in the duration field on a PM then 1 turns to 0.9999999. How can I fix this so it just says 1 even in the PM?