Hi

I am trying to calculate extra hors worked above 7.5 hrs.

In column c2 = start time (custom format hh:mm)
In column d2 = finisha time (custom format hh:mm)
In column e2 = extra hours (formula =(D2-C2)-7.5 and cell is custom format hh:mm) reply i get is #######.

PLease can someone tell me what i am going wrong.

example below

c2= 06:00
d2= 17:00
e2= d2(17:00)- c2(06:00)- 7.5 result should be 3.5hours.

Any help appricated.

Regards