=MOD(Time Out - Time In,1)*24

e.g.

=MOD(B2-A2,1)*24

Format cell as General

HTH

"RKS" wrote:

Sir,

Pl help me calculate the hours. I have two col A & B
A B C
Time In Time Out Working Days

17:00 ( 5pm) 02:00 a.m. (Next Days) = 9 hours
17:00 15:00 p.m. (next days) = 22 hpurs

how i can apply formula.

RKS