請問在EXCEL中要將秒數轉換成數值的方法例如2(秒)=2(阿拉伯數字)因為需要計算一些數值需要這樣的結果2(阿拉伯數字)*1.6=3.2(阿拉伯數字)如果用2(秒))*1.6≠3.2(excel會顯示3,雖然可以將3.2顯示出來,但格式還是”秒”)謝謝-----------------問題自行解決了...-----------------
In Excel,1 = 1 day1/24 = 1 hour = 1:00:001/24/60 = 1 min = 00:01:001/24/60/60 = 1 second = 00:00:01For your situation, you need to make it bigger first00:00:02 is input in A11.6 is input in B1In C1, input the formula= A1*24*60*60*B1You will get 3.2