Converting Time from text input to time format

Hello everyone, I have a report with time shown in a text format and inconsistent with the format. Can someone assist with how to extract time out a format like x days x minutes x hours? please ...

excel

Formulas and Functions

SergeiBaklan

Aug 14, 2023

Ashar2200

As variant

=TEXTBEFORE(D2, "Days", , , , 0) +
    RIGHT(TEXTBEFORE(D2, " Hours", , , , 0), 2) / 24 +
    RIGHT(TEXTBEFORE(D2, " Minutes", , , , 0), 2) / 24 / 60 +
    RIGHT(TEXTBEFORE(D2, " Seconds", , , , 0), 2) / 24 / 60 / 60

ConvertTime.xlsx15 KB

SergeiBaklan

Diamond Contributor

Aug 14, 2023

Ashar2200

As variant

=TEXTBEFORE(D2, "Days", , , , 0) +
    RIGHT(TEXTBEFORE(D2, " Hours", , , , 0), 2) / 24 +
    RIGHT(TEXTBEFORE(D2, " Minutes", , , , 0), 2) / 24 / 60 +
    RIGHT(TEXTBEFORE(D2, " Seconds", , , , 0), 2) / 24 / 60 / 60

ConvertTime.xlsx15 KB

Ashar2200
Copper Contributor
Aug 14, 2023
Thank you so much for this, it worked perfectly and i apricate your help.

Forum Discussion

Converting Time from text input to time format

Resources