Hi there,
My head is stuck, perhaps its due to being my first day at work this week :/
I'm looking to solve this excel mystery which has been haunting me since last week.
I'm trying to find out how:
1. To determine the minutes (potentially hours) between two times eg. Scheduled time of Arrival (STA) 08:00 and Actual time of Arrival (ATA) 08:16 = +
0:16mins
2. Conditional formatting that same (=) cell to colour code <15 is green and >15 is red.
Thank you!!
Bookmarks