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
