Most RecentMost ViewedMost LikesConvert multiple combinations of date text strings into a seconds Hi everyone! Maybe someone can help me with this problem... I'm using a software to manage telemarketing campaigns. This software allows me to create several informs and one of them is to know of much time an operator is logged in a campaign. The problem is that the output is in text format and with multiple combinations such as: - 2d19h20m55s - 4h58m56s - 15h37m5s - 21m55s - etc. My goal is to create a function that can convert all of this possible combinations in seconds. I started with this =+LEFT($C4;FIND("d";$C4;1)-1)*24*60*60 but now I'm stocked. Is it that possible or I have to create a function for any possible combination? Thanks in advance. SolvedExcel- 11/13/2017 10:01 PM to display as - 11/13/2017 22:01:00 using excel 2007 I want my date - 11/13/2017 10:01 PM to display as - 11/13/2017 22:01:00 I tried text(), datevalue() but no luck. can someone help ?
