Hi guys. I was hoping someone might have an easy solution for turning:

0722 in a cell (representing 7hours 22 minutes)

into

7 H 22 M

where anytime 4 numbers are typed into N2:N1000, it will auto convert it to # H # M.

Another example: I type 0815 into cell n2 and hit enter. It converts to 8 H 15 M.

Thanks.