Formula to get no of hours

[jackt05]

Hi,

May be simple for all
but I am not getting it

I have IN TIME and OUT TIME everyday for employees.
If each employee is working for 12 hrs everyday.
How will I get total hours at the end of the month

Please help me

 

[Andrew Poulsom]

Try:

=IF(AND(ISNUMBER(A1),ISNUMBER(B1)),MOD(B1-A1,1),0)

 

[jackt05]

Thank you Mr Andrew Poulsom now it has become perfect

Thanks a Lot

 

[Domski]

Try: =IF(A1="Absent",0,MOD(B1-A1,1))

Dom