Aziz Sathion! agar excel ke aik cell mein time likha ho 2hrs 30 minutes to dosray cell mein kia formula lgaye ke wo 2:30 show ho jye?
Please help...
Aziz Sathion! agar excel ke aik cell mein time likha ho 2hrs 30 minutes to dosray cell mein kia formula lgaye ke wo 2:30 show ho jye?
Please help...
Bohat bohat shukira king khan84 bhai,lekin yeh formula nhi ha mujhe eisa formula chahieye jo ke single cell mein time to digital format yani 02:30 format mein change kardein.
Its not possible because you are wanting a thing in which roman words included, you can not get anything which shows you the result in as you want.
یہ لو بھائی اس فائل میں وہ فارمولا موجود ہے جس کی آپ کو ضرورت ہے
بھائی ٹرائی کریں فارمولا لگانے کی میں بھی کرتا ہوں
Last edited by Sahil_Jaan; 22nd December 2017 at 09:48 PM.
2hrs 30 minutes =REPLACE(REPLACE(REPLACE(A2,2,4,":"),5,1,""),5,7," ")
Try this one
Here is another take
if length is always the same as per your screenshot than
and custom format your colum as "h:mm"Code:=TIME(LEFT(A2,1),MID(A1,8,2),0)
if your text length varies then use "IF" formula with combination.
Change ranges, references accordingly
regards,
Bookmarks