就是想得到时间差为1小时,我应该怎么做呀?
(DATETONUMBER(TODATE("9:50","HH:mm"))-DATETONUMBER(TODATE("8:50","HH:mm")))/1000/60/60
参考:日期与字符串相互转化-https://help.fanruan.com/finebi/doc-view-1346.html
日期函数概述-https://help.fanruan.com/finebi/doc-view-7.html