Hi Everyone,
I came across a problem with the tool i'm creating. This is like a time in motion tool where if the person clicks on start, it shows the timestamp, total duration, etc. What I want is a timer between clicking start and stop. I've attached my file for your reference. The timer I placed in J8 shows the running time = now, what I need is a timer that restarts, and gets back to 0 seconds.
Password is markusvirus
Thank you!
Neat. Didn't know you could do that. Try using a 'RUNNING_COUNT' that starts at zero and increments by 1 second - then instead of calculating 'NOW()' in the worksheet - you can just assign the value of running count to that cell.
Also - 86400 is the number of seconds in a day. So, divide by 86400 turns the running count into a decimal timestamp.
Try this:
Please Login or Register to view this content.
Last edited by GeneralDisarray; 11-03-2015 at 10:39 AM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Exactly what i needed! Thank you so much!!!
Also - you could leave your code alone and just replace your formula in J8 with this:
Please Login or Register to view this content.
Just another idea. :D
hi, i have a follow up inquiry about the file i have. I included a drop down list for Call types, which is being counted as well. What I'm trying to achieve is to average the duration per number of entries based on call type. Can you help me with this?
See attached.
I would just extend the table (see attached) and use an AverageIF() formula - Copy this formula to K21, then copy/paste down the table as needed for the averages.
Please Login or Register to view this content.
thank you so much @GeneralDisarray, one more thing, is it possible for all entries that instead of them being placed on the next row, the previous entries would go down so the current item would always be on top?
hi!
thank you so much @GeneralDisarray, one more thing, is it possible for all entries that instead of them being placed on the next row, the previous entries would go down so the current item would always be on top?
pls disregard
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks