The date in A1 will give you a serial number representing 00:00 ; i suggest you add half
a day (0,5) to that so you start counting at 12 noon.

Formula in A3 can be =((A1+0,5+A2/24)-Now())*24