astokes8Copper ContributorMar 23, 2022SolvedChanging data to hours 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? Starrysky1988 to astokes8Mar 23, 2022astokes8astokes8It works.=(LEFT(A1,SEARCH("d",A1)-1)+TIMEVALUE(SUBSTITUTE(RIGHT(LOWER(A1),LEN(A1)-SEARCH(" ",A1)),"h",":0")))*24&"h"
Starrysky1988 to astokes8Mar 23, 2022astokes8astokes8It works.=(LEFT(A1,SEARCH("d",A1)-1)+TIMEVALUE(SUBSTITUTE(RIGHT(LOWER(A1),LEN(A1)-SEARCH(" ",A1)),"h",":0")))*24&"h"
Starrysky1988 to astokes8Mar 23, 2022astokes8astokes8It works.=(LEFT(A1,SEARCH("d",A1)-1)+TIMEVALUE(SUBSTITUTE(RIGHT(LOWER(A1),LEN(A1)-SEARCH(" ",A1)),"h",":0")))*24&"h"
Vairavan_Shanmugam69Copper ContributorMar 23, 2022 DayHoursHoursHours116"=O17*24+P1716 Hope answer your questionastokes8
