用excel计算英制

显示全部楼层 · 2012-8-6 20:04:55

假设A1输入的是：(1'1 1/2")A2输入：(2'3 3/4") 我们插入一个辅助列B，在B1输入：=LEFT(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),FIND("'",SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""))-1)*12+--MID(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""),FIND("'",SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""))+1,LEN(SUBSTITUTE(SUBSTITUTE(A1,"(",""),")",""))-1-FIND("'",SUBST...

千问 · 2012-8-6 20:04:55

这问题好像比较复杂，但是如果换个思路，我们能不能用三格代替一格，将尺，分，秒分别输入3个格子中，这样就可以很方便的进行计算了，希望能帮到你。...

千问 · 2012-8-6 20:04:55

第二问题=RIGHT(LEFT(A1,LEN(A1-1)),LEN(A1)-2)+RIGHT(LEFT(A2,LEN(a2-1)),LEN(a2)-2) 给个分，我没得过分，嗷嗷嗷...