Excel Tips:
1. Convert Xd Xh, e.g. 2d 3h to hours
=IF(ISNUMBER(FIND("d",A1)),LEFT(A1,FIND("d",A1)-1)*8)+IF(ISNUMBER(FIND("h",A1)),MID(0&A1,MAX(1,FIND("h",0&A1)-2),2))
1. Convert Xd Xh, e.g. 2d 3h to hours
=IF(ISNUMBER(FIND("d",A1)),LEFT(A1,FIND("d",A1)-1)*8)+IF(ISNUMBER(FIND("h",A1)),MID(0&A1,MAX(1,FIND("h",0&A1)-2),2))
No comments:
Post a Comment