I have a sheet - 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 |
Here, say my toilet time would be from 6:00am to 6:15am
I want 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 Exercise ? in C1
Using the if function for time comparison and a lookup should solve my requirement, right?
Please help. How do I put the if function inside the lookup?
| 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 |
Here, say my toilet time would be from 6:00am to 6:15am
I want 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 Exercise ? in C1
Using the if function for time comparison and a lookup should solve my requirement, right?
Please help. How do I put the if function inside the lookup?