rnhturner1
asked on
Date and Time Questions in Access 2013
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
PatHartman
I realize that some people think that all participants should get a trophy but surely you didn't use all three methods. There are occasions where it makes sense to split the award because it took the contributions of multiple people to get to the solution but here we have three completely different options. I would have expected you to choose one option to award all the points and thank the others. I assure you that even though I think my solution is the best given that it provides tested code that you can simply copy into your app and call, I would not have been offended if you had awarded the points to the solution you actually used.
ASKER
I am new to this site. And I am a newby to ACCESS. I don't even know how to use the code you gave me. I am left to still figure it out on my own, since I needed more detail. I do appreciate your help and more than likely it is the best solution, but I don't know yet.