表格中：8小时52分钟31秒，怎么换算为分钟，结果为：8*60+52+31/60=532.5167
答案:2 悬赏:40 手机版
解决时间 2021-04-05 21:31
- 提问者网友：心牵心
- 2021-04-05 14:21
表格中：8小时52分钟31秒，怎么换算为分钟，结果为：8*60+52+31/60=532.5167
最佳答案
- 五星知识达人网友：渊鱼
- 2021-04-05 14:30
输入
=TEXT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"小时",":"),"分钟",":"),"秒",""),"[S]")/60
=TEXT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"小时",":"),"分钟",":"),"秒",""),"[S]")/60
全部回答
- 1楼网友：污到你湿
- 2021-04-05 15:39
=SUBSTITUTE(SUBSTITUTE(A1,"小",),"钟",)*1440
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯