Excel Formula Help on Time Calculation

[grcshekar]

Hi,

Ref to attached sample, Row 27, The Column L should show 3 hours but it is showing 27 hours !!

Request help please

[Pepe Le Mokko]

Your formula in the entire col K is inconsistent
the first row is =IF(I3<>"";I3-H3+(C3<B3);"")
What has HARISH (col B and C)have to do with KUMAR (col H and I)?
Shouldn't it be =IF(I3<>"";I3-H3+(I3<H3);"") (and dragged down)