How many watts per hour will a unit that is rated at DC 12V 500mA consume?

Power = volts x amps, so your example will be 12 x 0.5 = 6 watts. (500mA = 0.5 amp)

Note we don't talk of 'watts per hour', it is just watts. 1 watt = 1 joule per second