- ·上一篇：excel怎么搞自定义序列
- ·下一篇：excel信息检索怎么退出
excel怎么设置数据乘倍数
2026-01-10 10:08:07
1.在excel中如何按照时间来乘以不同倍数
C1=MIN(80,IF(AND(TIME(HOUR(A1),MINUTE(A1),SECOND(A1))>=TIME(6,0,0),TIME(HOUR(A1),MINUTE(A1),SECOND(A1))<=TIME(8,0,0)),2,IF(AND(TIME(HOUR(A1),MINUTE(A1),SECOND(A1))>=TIME(9,0,0),TIME(HOUR(A1),MINUTE(A1),SECOND(A1))<=TIME(16,0,0)),3,IF(AND(TIME(HOUR(A1),MINUTE(A1),SECOND(A1))>=TIME(16,0,0),TIME(HOUR(A1),MINUTE(A1),SECOND(A1))<=TIME(23,59,59)),4,0)))*B1）下拉。