Days Elapsed and Hours Elapsed in Access 2013
Posted on 2015-01-21
I have some Tables that I am not allowed to touch as far changing data types or data in it. I need to create a query that another data base is going to be pulling from.
I have two columns that have the DataType set as Numbers using the m/dd/yyy h:nn format (not date/time)
I need to take the difference of these columns and show as two new columns
DaysElapsed (needs to be in decimals - like 1.23 days)
HoursElapsed (needs to show more than 24 hours, so if it took an exact day and one half, the number would 36
My end goal is that I am working in another system that needs these showing in the above format.