Date and Time Questions in Access 2013
Posted on 2015-01-06
USING ACCESS 2013
Two of the fields that I am trying to use are
Created Time - which will look something like - 1/10/2013 2:04:00 PM
Closed Time - which will look something like - 2/28/2013 8:17:00 AM
I want to create another column that will calculate the total time this ticket was open.
HH:MM or Days,Hours, Minutes may work good too.
The problem is that when I try to do this, it only shows up to 24 hours. How can get it to show properly.