如图,是当前时间!
=IF(AND(TIME(HOUR(NOW()),MINUTE(NOW()),0)>A1,TIME(HOUR(NOW()),MINUTE(NOW()),0)<A2),"是","否")