kia koi mughay formula bata sacta hay dates conversion ka jaisay : 7th day ko 03:30 mayn say 06th , 13:06 minus karna hay in excel like ,
date hr mins
07 03 30
06 13 06
---------------
00 14 24 ( its ans )
is ka koi formula bata sacta hay ???? plz
kia koi mughay formula bata sacta hay dates conversion ka jaisay : 7th day ko 03:30 mayn say 06th , 13:06 minus karna hay in excel like ,
date hr mins
07 03 30
06 13 06
---------------
00 14 24 ( its ans )
is ka koi formula bata sacta hay ???? plz
Dear excel me date maloom karnay ka formula yeh hai. Blank cell par ja kar yeh code likho. =now()
nice sharing janab.
thnx
thanks a lo t let me check...
zaroor
tassali kar leejiay
bus itna khayal rakhiay ga entry kay waqt kay entry kaisay karni hay, ager aap nay pattern change kiya to ghalti ho sakti hay. is liay patern 1 jesa he rakhiay ga, jahan tak aap nay sum ki range dee ho gi.
mm(dash)dd(dash)yyyy(space)hr(colun)mn(enter)
where
mm=month
dd= date
yyyy=year
hr=hour
mn=minute
date or time kay darmayan space dena hay.
date main shayed (slash) bhee kaam kar lay, check kar leejiay ga.
Bookmarks