たか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
たか2021/04/16 13:18:541200pt
たか2012/08/17 19:12:39100pt
たか2011/01/07 09:15:2335pt
たか2011/01/06 15:41:06100pt
たか2007/05/07 16:45:04250pt
たか2007/04/18 17:47:33100pt
たか2007/03/22 17:17:0950pt
たか2007/02/07 14:22:3360pt
たか2007/01/27 09:08:4160pt
たか2006/08/22 13:51:4835pt