2 hours 30 minutes =REPLACE(REPLACE(A2,2,7,":"),5,8,"")
Senior Member+
2 hours 30 minutes =REPLACE(REPLACE(A2,2,7,":"),5,8,"")
Senior Member+
2 hours 30 minutes =REPLACE(REPLACE(A2,2,7,":"),5,8,"")
V.I.P
Advance Member
Aap sab bhaion ka bohat bohat shukira mera masla hal hogya hay.
Syar Sahib bohat hi shukira ap ne pehl bhi hobat ziada help ki hay, agar IF combination ke sath us ka istemal bta dein to bohat bohat shukria..
Senior Member+
try this one formula =TIME(MID(A1,1,1),MID(A1,6,1),)
Posting Permissions
Reply With Quote
2.gif "Smile::")
Bookmarks