Hello,
I've built a rudimentary spreadsheet to help our healthcare team plan and keep track of annual leave. I want a formula where Excel will recognise the word "LEAVE" in the cell and also perform a sum of hours people input next to it i.e.
Taken C D
12. "LEAVE 7.5" "LEAVE 5"
It feel like it should be doable but I can't figure it out. Any help?
John
Bookmarks