新人求助停车费计算公式

Holiday2022

你这样老师们很难帮你

boyuanoffice

1. =LET(H,SUM(SORT(INDEX(FILTER($B$2:$B$7,$A$2:$A$7=C11),{1;2}),,-1)*{24;-24}),
   
2.     IFS(H<=0.5,0,H<=1,2,H<=24,ROUNDUP(H,0),TRUE,ROUNDUP(H/24,0)*15))
   

复制代码

过车信息.7z (10.3 KB, 下载次数: 4)

2024-3-8 13:57 上传

点击文件名下载附件

ifan0916

1. =IFERROR(MIN(SUMPRODUCT(TEXT(TEXT(C2-B2,"[mm]")/60-{0.5,1,1},"0;!0;0;")^{0,0,1}*{0,2,1}),15),0)

复制代码

ifan0916

计算规则不够细，超过1小时，不足2小时按1小时还是2小时计时没说清

啸海

=IF(MOD(ROW(A1),2),MAX(,INT(C2-1/48))*15+SUM(MOD(CEILING(TEXT(C2-1/48-{0;0.0416666666666667},"[<]!0"),1/24),1)*{48;-24})-(C2>=1),"")

风扇Facha

=IF(E11<1,CHOOSE(MATCH(ROUND((E11-INT(E11))*24,0),{0,0.5,1,14}),0,2,ROUND((E11-INT(E11))*24,0)+1,15),INT(E11)*15+CHOOSE(MATCH(ROUND((E11-INT(E11))*24,0),{0,0.5,1,14}),0,2,ROUND((E11-INT(E11))*24,0)+1,15))

jacke8

风扇Facha 发表于 2024-3-8 23:35
=IF(E11

通过你这个公式计算79:59.34小时这个得￥126，不对吧

风扇Facha

没有啊 我显示的是54.
=IF(C6<1,CHOOSE(MATCH(ROUND((C6-INT(C6))*24,0),{0,0.5,1,14}),0,2,ROUND((C6-INT(C6))*24,0)+1,15),INT(C6)*15+CHOOSE(MATCH(ROUND((C6-INT(C6))*24,0),{0,0.5,1,14}),0,2,ROUND((C6-INT(C6))*24,0)+1,15))

丢丢表格

风扇Facha 发表于 2024-3-10 22:56
没有啊 我显示的是54.
=IF(C6

时间的东东，搞不好就出现浮点问题。。。。。  该补差。


=IF(C2,MIN((C2*24>0.5+1%%)*2-INT(-MOD(C2,1)*24)-1,15)+INT(C2)*15,"")