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.
Bookmarks