I know there are loads and loads of answered questions concering this topic, but either they don't exactly fit what I was looking for, or I simply don't understand the answers enough to implement them in my own project. I'm an Access 2007 Newb, and VBA programming is, so far, well beyond me, so please be patient with your answer, I'll need as much step-by-step detail as possible, and i will try to provide enough information for you to work with.
Okay, so, this is what I'm working with:
I was tasked by my wife to create an Access Database for tracking work calls that she takes. This DB is going to be for tracking length of call, per minute rate for the call, and money earned on the call AFTER the per minute overhead is deducted. Not really having much of an idea as to where to begin, I downloaded the template on Microsoft.com called "Call Tracker", thinking that this might already be exactly what I was looking for. Needless to say, it wasn't, so I began the process of MAKING it into what I needed it to be. So I've made a bunch of changes, and now have the following question:
I have a table called "Calls" and a form called "Call Details" (I realize these don't really meet standard naming conventions, but I didn't mess with the names of anything, I just left them the way they were in the template for fear of totally messing things up)
On the form "Call Details", I have:
Text Box One: [Start Time] with button, btnStart, which, when pressed enters current time in [Start Time]
Text Box Two: [End Time] with button, btnEnd, which, when pressed enters current time in [EndTime]
Text Box Five: [PerMinute], used for the user to enter the per minute rate for that particular call
Text Box Four [TotalTime], which displays the results of a calculation done by pressing a button, btnTotal
The Following code is on btnTotal, which is pressed in order to fully calculate the length of time for that particular call. I used:
[TotalTime] = (DateDiff("s", [StartTime], [EndTime]))
So this will only output the difference in time in Seconds, which I can use by diving by 60 and then multiplying by the per minute rate, ect, for my other needs. I would have gone with minutes, but her calls are tracked by the second, so easier to go with seconds for the other calculations, but what I'd like is for the user to not have to see a bunch of seconds, but to be able to see something such as 5:25 instead of 325. I've tried multiple things but still can't figure out what I need to do simply to make this display properly and still be useable for other calculations which need to be made based off of this number.