Coming and out going time

Closed
jetfrancis Posts 1 Registration date Monday January 27, 2014 Status Member Last seen January 27, 2014 - Jan 27, 2014 at 12:19 AM
I ampreparing in excel with in coming and out going time,But for the average time i am taking as for 5 hours a day,If any employees works for more that 11hours my formula shows as 2present instead of 1present-INT(F157/"5:00")&" PD "&TEXT(MOD(F157/"5:00",1)*5/24,) the same 2P has to conver into P only,Please help me in this regards

JET.Francis