Coming and out going time [Closed]

Report
Posts
1
Registration date
Monday January 27, 2014
Status
Member
Last seen
January 27, 2014
-
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!