Couldn't find where to put this so thought i'd throw it in here.
Could someone tell me how to format cells in excel so that they change a text value into a work shift;
Like changing 8/6 or 86 into 8:00/6:00?
I know its beng lazy but my manager isn't exactly einstein so need to make these thngs idiotproof.


