excel help

[alim khan]

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 ??

[The Genius]

Simple math wala forumula lage ga.
Difference sirf itna he k cells ko right click kar k format main time kar do.

[alim khan]

Simple math wala forumula lage ga.
Difference sirf itna he k cells ko right click kar k format main time kar do.

BHAI NOT WORKING EK BAR ATTACHEMENT DEKHEN..

[The Genius]

Poori baat follow nhin ki apne

Attachment check kro, working fine.

[Cr ahmed]

kuch samajh nahi aya

[alim khan]

Poori baat follow nhin ki apne

Attachment check kro, working fine.

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...

[The Genius]

Check this

[alim khan]

Check this

not working............

[The Genius]

not working............

Screen shot do.
Mere pass working he.

[alim khan]

Screen shot do.
Mere pass working he.

bhai 13.45 aur 14.15 minute ka difference kitna hota hai... 30 minute
ya phir bhai 15.30 aur 16.30 minute ka difference kitna hota hai... 60 minute

bus mujhe ye formula chahiye.....

[The Genius]

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.

[junaid b]

bhai sahi keh rahi he