Hi everyone!

I would like to ask how to formulate my problem in creating my template of computing hours worked during fixed holidays and floating holiday in a cell.
If I worked during holiday regardless if it's fixed holiday (Christmas, All Souls Day, etc.) or floating holiday (Edi'l Fitr, Thanks giving, National Heroes Day etc.), how can I reflect the hh:mm that I have rendered. And between the date what formula for the night differential hours (it begins at 10:00 PM and ends at 6:00 AM of the next day) for it to determine or to plot in separate cell.

Any help will do.

Thank you in advance.