How to calculate 8 as 1 and 4 as 0.5 in excel

[asksign]

Hi,

I am dealing with 400 employees in an organization, I need help to maintain attendance report. We are working 8 hours a day and 4 hours as half-a-day. I have to calculate 8 as 1 and 4 as 0.5 for the day for an employee. Please help me on this.

 

[asksign]

Thankyou Melisen

 

[asksign]

It works fine.
Thankyou Rory,