Coming and out going time [Closed]

Report

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
Post cannot be loaded at this time ✓ - Forum - Facebook
Aol network connection timed out ✓ - Forum - WiFi
The connection has timed out ✓ - Forum - Firefox
This is because you tried to do something too many times. please try again later. ✓ - Forum - Facebook
Ps3 ip address timed out - How-To - PS3

Coming and out going time [Closed]

Your reply

Subscribe To Our Newsletter!