网页资讯视频图片知道文库贴吧地图采购
进入贴吧全吧搜索
excel吧 关注：281,537贴子：1,552,519
  • 7回复贴，共1页

计算时长

2024年9月21日12时46分-2024年9月21日20时51分
像这种情况怎么用公式计算时长，精确到小时？


直接相减，然后乘以24


2025-09-03 00:11:59
广告
不感兴趣
开通SVIP免广告
=(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"年","/"),"月","/"),"日"," "),"时",":"),"分","")-SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1,"年","/"),"月","/"),"日"," "),"时",":"),"分",""))*24




=NPV(-2,BYROW(--(TEXTSPLIT(A1,"日","-")&{"日",""}),SUM))


扫二维码下载贴吧客户端

下载贴吧APP
看高清直播、视频！
  • 7回复贴，共1页
分享到: