Need MS Access logic to calculate difference between two times stored as a number 0000 to 2400
Posted on 2012-04-05
I need to compute the difference between two time fields stored as numbers in military time. I have tried just subtracting them, and it works for most times, but when I try to get the difference between say 0745 and 0808, it gives me 63 minutes instead of 23 minutes because of the 10 base instead of 60 base logic. I have tried multiple functions including the Datediff function using the 'n' data type, but I can't get it to work correctly. Any help would be appreciated.