Excel expert help me...

[Rizwan Anjum]

Dear maine ik employee time sheet bnai hai...es mei mujhe formula adjust kerna hai...1st Time In se le kr 2nd Time out tk jo time banta hai wo Normal k column mein ajye..pls help me...sheet add hai...

[The Genius]

File is attached

[Rizwan Anjum]

File is attached

Dear es mein jo short time ka column ha, us mein agar employee 09:00 bje k bad in kre to jitne minut late in kre gay wo time short consider hina chahye or 05:30 se jitne minute pehle out kre wo b short time mein ana chahye...pls formula adjust ker dain....file attach hai with example

[Rizwan Anjum]

hello

[Rizwan Anjum]

late timing calculate krni hai,

[Rizwan Anjum]

hlloooooo

[The Genius]

Short time ka column konsa he??

[Rizwan Anjum]

Normal se next O.T ki jaga short time kr dain...