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

Coming and out going time
Poppy play time - Download - Horror
We can’t review this decision because too much time has passed since your account was disabled. ✓ - Facebook Forum
Popcorn time - Download - Movies, series and TV
Whatsapp time setting - Guide
Keyboard typing letters and numbers at the same time ✓ - Windows Forum

Subscribe To Our Newsletter!