Mar 23 2022 06:45 AM
I have data that has been entered in days and hours; i.e. 1d 16h. Is there a way to use a formula to change this data to hours; i.e. 40h?
Mar 23 2022 06:54 AM
Mar 23 2022 07:43 AM
Mar 23 2022 11:20 AM
Mar 23 2022 11:30 AM
SolutionMar 23 2022 11:30 AM
SolutionIt works.
=(LEFT(A1,SEARCH("d",A1)-1)+TIMEVALUE(SUBSTITUTE(RIGHT(LOWER(A1),LEN(A1)-SEARCH(" ",A1)),"h",":0")))*24&"h"