excel mein ek formula chahiye.
In Out Total Minutes
10.30 11.00 30
11.30 12.00 ?? yahan per mujhe formula chahiye.
12.30 13.00 ??
13.00 13.30 ??
excel mein ek formula chahiye.
In Out Total Minutes
10.30 11.00 30
11.30 12.00 ?? yahan per mujhe formula chahiye.
12.30 13.00 ??
13.00 13.30 ??
Simple math wala forumula lage ga.
Difference sirf itna he k cells ko right click kar k format main time kar do.
Poori baat follow nhin ki apne
Attachment check kro, working fine.
kuch samajh nahi aya
Bhai IN TIME aur OUT TIME ke beech ka difference jo ki minute mein hoga.woh mujhe likhna padta hai.isiliye mai chahta hun ke koi formula ho to batao.
exmp. (1) agar mai kahin per 10.30 IN hota hun aur 11.00 baje OUT hota hun to is ka matlab ke maine wahan per 30 minute guzare.
exmp. (2) agar mai kahin per 13.15 IN hota hun aur 13.55 baje OUT hota hun to is ka matlab ke maine wahan per 40 minute guzare.
In Out Total Minutes
10.30 11.00 30>>>>> yahan per mujhe formula chahiye...
Check this
Maine jo file di he uss main
13:45 aur 14:15 likh kar dekho
13.45 nhin likhna ye standard time format nhin he.
bhai sahi keh rahi he
Bookmarks