Add timer functionality to Google Sheets spreadsheet
$10-30 USD
Closed
Posted over 6 years ago
$10-30 USD
Paid on delivery
I'm trying to make a Google Sheets spreadsheet that can help me track my time spent on the tasks assigned to me. I can provide the Google Sheets spreadsheet shown with totals working but no button functionality
As I see it, I would like two types of buttons:
Play/Pause button:
▶️ (initial state), when pressed, starts stopwatch counting up for that row. (also changes image to ⏸ & pauses any other stopwatches in sheet which may be counting up, only one row would be actively counting up at any time, with the addition of the total time counting up)
⏸ when pressed, stops stopwatch (also changes image to ▶️ )
Completed button:
⬜️ (initial state), when pressed, stops stopwatch for that row if its counting up (also changes image to ✅ )
✅ when pressed, switches image back to ⬜️)
I would input into "work" & "predicted time (m)" columns - you don't have to deal with that.
"elapsed time" would be blank until time is recorded there through the buttons. I must be able to copy & paste more rows (up to 100), all with timer functionality as I get more tasks.
Thanks so much!
Hello,
I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional.
Below are some key areas of my skills:
-- VBA and Excel,Word,Office Applications
-- Expert on C# using .NET framework using Visual Studio 2012 and 2013
-- Expert in VB.NET using VS2012/VS2013
-- WPF and Windows Forms Application
-- Expert in ASP.NET,MVC
-- JS,Google extensions and google scripts
I have experience in all the above areas and during my project work I have completed all of the above tasks.
As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best.
Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution.
Would be looking forward to work on this opportunity and will ensure to deliver best.
Regards,
Abhinov