Track time using Shortcuts


I’m trying to create a Shortcut that will add data to a Numbers file. There may be an easier way to do this - so I’m open to suggestions.

Here is what I am trying to accomplish:
I want to create a shortcut that I run at a specific time - I want to capture the day, date, and time. I want to add this to a Numbers file.

I would like to create a second shortcut that I run at the completion of the event - I want to capture the time and then add this to the same row of the above numbers file.

The columns I have are: Day, Date, Time Start, Time End, Total Time. (the Total Time column would be a formula to total the time).

What I can’t figure out is how to append the end time to the same row.

Any help or suggestions will be appreciated.

Have you considered storing the start time with the first shortcut and then writing both the start and end time together to the same row in the second shortcut?

Hi - thanks for the reply. I thought of doing that using Data Jar, but couldn’t figure out how to store the time entry. Any examples would be appreciated.

Try this.

That worked! Thanks for your help.