たか2022/07/03 16:46:06200pt
=IF(OR(TIME(HOUR(A1),MINUTE(A1),SECOND(A1))<=TIME(2,0,0),TIME(HOUR(A2),MINUTE(A2),SECOND(A2))<=TIME(2,0,0)),3000*A3,0)A1 or A2 が24時(0時)~2… たか2022/06/14 10:39:09100pt
たか2022/06/13 13:32:2530pt
たか2022/07/03 16:46:06200pt
=IF(OR(TIME(HOUR(A1),MINUTE(A1),SECOND(A1))<=TIME(2,0,0),TIME(HOUR(A2),MINUTE(A2),SECOND(A2))<=TIME(2,0,0)),3000*A3,0)A1 or A2 が24時(0時)~2… たか2022/06/14 10:39:09100pt
たか2021/09/22 13:38:44500pt
たか2021/05/07 15:51:13600pt