If you put (in B1)

=A1-TIME(0,3,0)

and format column B as a date that should work.

(or do you need it in Standard time even in the middle of summer, i.e. account for Daylight Savings)