I need to enter a clock in and clock out time and then convert this to hours.

I tried this formula =(QUOTIENT(B1,100)-QUOTIENT(A1,100))/24+(MOD(B1,100)-MOD(A1,100))/1440+IF(B1<A1,1)

But I keep getting the #NAME Error....

Can someone please help me out?

I tried this formula =(QUOTIENT(B1,100)-QUOTIENT(A1,100))/24+(MOD(B1,100)-MOD(A1,100))/1440+IF(B1<A1,1)

But I keep getting the #NAME Error....

Can someone please help me out?

## Comment