Agar 10:30 AM me se 11:30 AM minus kare to esko excel me kese (formula ke tahat) ghatayege ya 10:30 AM me se 11:30 PM ko, koi formula to hoga hi, marbani kar ke mujhko ye bataye.
Sukriya
Agar 10:30 AM me se 11:30 AM minus kare to esko excel me kese (formula ke tahat) ghatayege ya 10:30 AM me se 11:30 PM ko, koi formula to hoga hi, marbani kar ke mujhko ye bataye.
Sukriya
Time minus ya difference maloom karne k leye koi special formula tu nahee hota except some special cases. Leekan aap k case m sirf aap ko simple minus k formula lagana ho ga.
suppose 10:30 cell a1 m aur 11:30 cell b1 m. Formula =a1-b1.
But ye aap ko ####### k error de ga. Ye formula is sorat m kam karega k aap
tool=====>option====>calculation k Tab m ja kar "Use 1904 date system""
ko chek kar dain aap ka masla hal ho jae ga.
Regards
please help me for this function
Mujhe aik formula chaiye jo ke hai 3.6 or 3-6 is ko convert karna hai pieces mai.
THank you.
Last edited by Sohailattari; 26th November 2009 at 10:04 AM.
Hurry up please help me for this function
Mujhe aik formula chaiye jo ke hai 3.6 or 3-6 is ko convert karna hai pieces mai.I will be thankful for this.
Bookmarks