calculate working hours excluding half day leaves

Hi Guys,

Can anyone help me on how to create a formula where it computes total hours worked within business hours (8 hrs) excluding full and halfday leaves?

Appreciate your utmost reply guys

Hi,

How do you decide half day working? Can you post a sample template in excel format please?

This is good if someone can help with this...