Ask Excel Expert

[Nadeem Ahmed Kh]

Mai excel me aap ki madad chahata hu, mere pas ek excel ki sheet hai jiske do columns me start time (04:35 PM) of end time (06:47 PM) hai ab agar me ye chahu ke end time me se start time ghata ke Minutes nikal aaye to kya formula chahiyega, ya fir time pure pure ghanto me nikal aaye wo kaise please madad kre Shyar Bhai........Kaha ho.............???

Shukriya.........

[Ghayyasg]

Suppose,
Start Time is In C3
End Time is In D3
Time Difference is In E3

Write Formula in E3
=D3-C3
and Set E3 format h:mm

Now I E3 you will see total time of presence..
I hope It will solution For your Work

[Nadeem Ahmed Kh]

Suppose,
Start Time is In C3
End Time is In D3
Time Difference is In E3

Write Formula in E3
=D3-C3
and Set E3 format h:mm

Now I E3 you will see total time of presence..
I hope It will solution For your Work

me ye chahata hu ke meenat nikal aaye ya fir time ghanto me nikal aaye yani ke ek hi format me aaye ya to minuts me ya ghanto me kisi bhi ek format me.......aap jo bata rahe hai wo to mujhe aata hi hai

ek or problems hai jaise ke manle mene koi kam ko 11:45 PM rat ko shru kiya or 12:15 AM rat hi ko khatm kya to aap ke bataye hua formula yahan pe fail ho jata hai or ########### likha aata hai, ..............excel expert where u r..............

[Nadeem Ahmed Kh]

me ye chahata hu ke meenat nikal aaye ya fir time ghanto me nikal aaye yani ke ek hi format me aaye ya to minuts me ya ghanto me kisi bhi ek format me.......aap jo bata rahe hai wo to mujhe aata hi hai

ek or problems hai jaise ke manle mene koi kam ko 11:45 PM rat ko shru kiya or 12:15 AM rat hi ko khatm kya to aap ke bataye hua formula yahan pe fail ho jata hai or ########### likha aata hai, ..............excel expert where u r..............

???????????

[Ghayyasg]

me ye chahata hu ke meenat nikal aaye ya fir time ghanto me nikal aaye yani ke ek hi format me aaye ya to minuts me ya ghanto me kisi bhi ek format me.......aap jo bata rahe hai wo to mujhe aata hi hai

ek or problems hai jaise ke manle mene koi kam ko 11:45 PM rat ko shru kiya or 12:15 AM rat hi ko khatm kya to aap ke bataye hua formula yahan pe fail ho jata hai or ########### likha aata hai, ..............excel expert where u r..............

Brother Basically to hours hi daikhay jatay hain working time k, magar apki requirement k mutabiq solution de rha hoon
Ap Ne jahan Result Show karwana hai wahan yeh Formula Put Karain

=(B1-A1)*1440

B1 ki jaga ending Time, Aur A1 Ki jaga Starting Time Put karna. Apko Reuslt Minutes me mil jaye ga.

Duaon Me yaad rakhiye ga,

ALLAH NIGAHBAAN

[syar]

salam::

please go through the below thread, agar aap ki kuch madad ho sake

http://www.itdunya.com/t300546-43/

especially post No.509 to 512. aur agar mumkin ho tu jis thread ka zikr in posts m kya ha use AAE k section m search kr lain.

regards

[Help4everyone]

abhi nh pta

[Nadeem Ahmed Kh]

Brother Basically to hours hi daikhay jatay hain working time k, magar apki requirement k mutabiq solution de rha hoon
Ap Ne jahan Result Show karwana hai wahan yeh Formula Put Karain

=(B1-A1)*1440

B1 ki jaga ending Time, Aur A1 Ki jaga Starting Time Put karna. Apko Reuslt Minutes me mil jaye ga.

Duaon Me yaad rakhiye ga,

ALLAH NIGAHBAAN

ye to nahi ho raha bhai.......... aap khud kr ke dekhe 11:45 pm start time or end time hai 12:15 am to end me se start time ko (-) krne se kuch or hi aa raha hai ...........dekhe screen shot

[Nadeem Ahmed Kh]

pls see this attached file.

[Ghayyasg]

ye to nahi ho raha bhai.......... aap khud kr ke dekhe 11:45 pm start time or end time hai 12:15 am to end me se start time ko (-) krne se kuch or hi aa raha hai ...........dekhe screen shot

Brother yeh formula within a day work karta hai, date change change honay pe yeh formula work nahi karta, es me mazeed behtri ki gujaesh mojood hai, jo k shayed main na kar paun, mere reply ke baad hi SYAR Bhai ne apko reply kia aur aik link bihi dia aap us link ko visit karain, main ne bhi check kia hai, ap ke maslay ka hal usi mai mojood hia, SYAR Bhai ne jo kaha wo ghaur se read karain aur phir us link ko vist karain especially un posts ko jin ka Zikr SYAR Bhai ne kia hai, Ummeed Hai Apka MASLA HAL HO JAYE GA, MAZEED REHNUMAI K LIYE RABTA KIJIYE GA , ALLAH NIGAHBAAN