The data validation is not calculated until you press the dropdown, which is why I asked when exactly you see the message. If you see it after entering...
Well, basically at every entry.
The real file has 10 more sheets (1-calc, 2-calc, 3-calc and so on) that have manual input (D2, d3 and so on) column....
Knowledge Base Articles By Category
Recent Forum Posts
Help with time duration calculation
See the first formula here: https://exceljet.net/formula/get-wor...ates-and-times with explanations.
p45cal 2022-05-13, 02:48 PMYou'll probably need a bit more...