Need help with OT Form.

something from my archive.
In sheet "My holidays" all the holidays in Belgium from 2012-2018. Adapt that to your holidays
then in the table starting in B21 of sheet1, you fill the green cells, date and 2 hours (start and end).
The working hours are divided in the following columns.
You can modify it to your needs.
If you work after midnight, for example in row 24, I worked untill 18:00 of the next day, that is 24+18=42 so I added there 42:00

hello kat1po and welcome to the forums

Thanks for the explanation and the spreadsheet, it is always an excellent idea to attach a sample spreadsheet to demonstrate you issue.

It is also a really good idea to show the forum members exactly what you think the result should be. In this case I suspect you want a number of normal hours and overtime hours shown at the very least.

You also need to think about your data entry here as well, how can you start at 5:00 and finish at 1:30 for example. The answer is clear, you are talking about 1:30 on day + 1 but the spreadsheet doesn't know that as you are not entering dates as well as times.

You will find forum members happy to assist to you get the information you need but it is NOT a good plan to expect them to actually develop your answer, it after all a "helping hand" place

Again, welcome, look forward to your next spreadsheet