I have a small doubt in excel, there is a data where employee working hours has been mentioned , we have to work on his working hours calculation. It is mentioned that there should always be a break of 10 minutes after every period of work of 2.5 hours, but the time under break won't get paid. So i am confused how to find total amount of breaktime using excel. Please enlighten the excel formula so that i can use it for the net paid working hours of employee. Please don't give manual calculation idea I know it's easy manually but I need to automate it using excel formulas. I hope u understand what I want. Thanks!!!

Day	Working hour Start from	Working hour Finish at	Amount of time spent in break (each of 10 minutes after a period of 2.5 hour of working)	Net amount of working hours to be get paid (Out - In - Total Break time)
Monday	10:00 PM	4:00 AM	?	?
Tuesday	6:00 PM	2:00 AM	?	?
Wednesday	9:12 AM	4:48 PM	?	?