MoOsEBoT88
New Member
- Joined
- Sep 13, 2011
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Hi,
I am looking to return the planned activity for the current hour for that Bay
So at 10:32am it should rounddown the 10:00 and show whats planned in for that bay for 10:00 - 10:59
I have this formula but its returning the wrong result.
=VLOOKUP(FLOOR(NOW(),1/24),Plan!A2:B14,2,TRUE)
Hope someone can point me in the right direction.
I am looking to return the planned activity for the current hour for that Bay
So at 10:32am it should rounddown the 10:00 and show whats planned in for that bay for 10:00 - 10:59
I have this formula but its returning the wrong result.
=VLOOKUP(FLOOR(NOW(),1/24),Plan!A2:B14,2,TRUE)
Hope someone can point me in the right direction.