I have a spreadsheet - daily routine which has two columns: activity and time as shown here
| Activity | Time |
|----------------------|----------|
| Sleep | 6:00 am |
| Toilet | 6:15 am |
| Get ready for gym | 6:30 am |
| Exercise | 7:50 am |
| ... more things | 9:00 pm |
| ... still more | 10:45 pm |
| Sleep | 6:00 am |
I wanted to find out, say in C1 which activity is current for me using now()
I.e., if it’s 6:45am on my watch, it should show me Exer