Evening everyone,
I am making a planner and currently attempting (Appallingly) to get it auto populate start and finish times time based on the acronym added for the project. I have been able to add it in by using the EXACT function, i tried the SEARCH function but fell short when i was asking for it return a value different for each searched string of text.
I have attached a screen shot of what I am looking at. The end goal here is when I type in the job acronym in the top row it will grab the start time, finish time, lunch break. From the key I have on the left. From there I will calculate hours worked for the day, then multiply by my rate for that project finally giving me breakdowns of total earned for each week and month.
If anyone can help it would be a big help, Thank you all.
I am making a planner and currently attempting (Appallingly) to get it auto populate start and finish times time based on the acronym added for the project. I have been able to add it in by using the EXACT function, i tried the SEARCH function but fell short when i was asking for it return a value different for each searched string of text.
I have attached a screen shot of what I am looking at. The end goal here is when I type in the job acronym in the top row it will grab the start time, finish time, lunch break. From the key I have on the left. From there I will calculate hours worked for the day, then multiply by my rate for that project finally giving me breakdowns of total earned for each week and month.
If anyone can help it would be a big help, Thank you all.