時間差 (小時) (12299)

C3=SUMPRODUCT((TEXT(LEFT(B3:B4,8),"0-00-00")+TEXT(MID(B3:B4,10,6),"00!:00!:00"))*{-1;1})*24



留言