EXCEL TIME HELP

[sohail1966]

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

[KingKhan84]

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

Please check the file

[sohail1966]

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.

[JehJah]

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.

[sohail1966]

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.

To bhai ap is ko eisa bhi parh saktey hay, two hrs thirty minutes.

[Sahil_Jaan]

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

کچھ دیر میں آپ کا مسئلہ حل کر دوں گا نیٹ کا ایشو ہونے کی وجہ سے فائل اپلوڈ کرنا مشکل ہو رہا ہے

[Sahil_Jaan]

یہ لو بھائی اس فائل میں وہ فارمولا موجود ہے جس کی آپ کو ضرورت ہے

[sohail1966]

یہ لو بھائی اس فائل میں وہ فارمولا موجود ہے جس کی آپ کو ضرورت ہے

Sahil_Jaan bhai mein jo chahta hoon wo attach kardia hay.

[Sahil_Jaan]

بھائی ٹرائی کریں فارمولا لگانے کی میں بھی کرتا ہوں

[sajidbagi]

2hrs 30 minutes =REPLACE(REPLACE(REPLACE(A2,2,4,":"),5,1,""),5,7," ")
Try this one

[sohail1966]

2hrs 30 minutes =REPLACE(REPLACE(REPLACE(A2,2,4,":"),5,1,""),5,7," ")
Try this one

Bhai Mein ne try kia tha to is tarah ka answer arha hay:

[syar]

Here is another take
if length is always the same as per your screenshot than

=TIME(LEFT(A2,1),MID(A1,8,2),0)

and custom format your colum as "h:mm"

if your text length varies then use "IF" formula with combination.

Change ranges, references accordingly

regards,