问题已解决
怎么用函數(shù)計算每一天和共花費幾個小時?
FAILED
![](https://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/010/18/30/83_avatar_middle.jpg?t=1651203970)
您好,F(xiàn)格可以填上:
“= E2-C2”
2019 03/16 17:23
![](https://pic1.acc5.cn/010/18/30/83_avatar_middle.jpg?t=1651203970)
沈家本老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 03/16 17:25
然后在i格填上24:00,然后G2可以填:
“= i2-C2”
![](https://pic1.acc5.cn/010/18/30/83_avatar_middle.jpg?t=1651203970)
沈家本老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 03/16 17:27
同理,Jo格填上00:00,然后H2可以填:
“= E2–J2”
![](http://member.chinaacc.com/homes/resources/images/home/avatar/9.jpg)
84784959 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 03/17 19:28
沒有函數(shù)公式計算嗎?
![](https://pic1.acc5.cn/010/18/30/83_avatar_middle.jpg?t=1651203970)
沈家本老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 03/17 19:30
您好,這個就可以算的
![](/wenda/img/newWd/sysp_btn_eye.png)