Timing with Funncitons

[Prashant3975]

Dear All Experts

i am New to Excel

so i don't know Formula's

I Wanted to Make a Sheet for Attendance with Time & Point Based to count Over Time.

Basically We are having small office with 3 Persons. so Wanted automatic Time Counter

My Office Time is 9:30 A.M to Evening 7:30

My Qurey is how to Calculate over times.


What we are having now, Every Half an hour is 00.50 Score for Over Time

Like Somebody Come Early in Morning instead of

Before Office time 9:30 A.M
9:00 A.M he Gets 00.50
8:30 A.M he Gets 01.00
8:00 A.M he Gets 01.50
7:30 A.M he Gets 02.00

Same thing in Evening

After 7:30 P.M Overtime Stats
8:00 P.M he gets 00.50
8:30 P.M he gets 01.00
9:00 P.M he gets 01.50
9:30 P.M he gets 02.00
10:00 P.M he gets 02.50
10:30 P.M he gets 03.00
1100 P.M he gets 03.50
11:30 P.M he gets 04.00

Can u Tell anyone how to do this automatic counting in Next Cell.

Reference Sheet Attached

Waiting for your Reply.