You can subtract hours like that even with a date - if you get #VALUE! that probably means your date isn't recognised as a date (and is treated as text) that might happen if your default format is m/d/yy - can you convert the dates?