Track time using Shortcuts

Shortcuts
1

Hello,

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.

2

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?

3

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.

4

Try this.

https://www.icloud.com/shortcuts/df9c2367e141417a91e0540a6eb5203a

5

That worked! Thanks for your help.