Re: Calculation net working hours when business end time is less than business start
I found this workbook and it has really given me a jumpstart, many thanks. I have a question regarding the Priority which references table 3: =LOOKUP([@PriorityTxt];Table3[P_Txt];Table3[Priority])
All looks OK apart from Low Prios which report the value back as 2 when I am expecting 4.
I've tested with excel 2010&13. I hope you can advise