Excel (yes, boring i know)

21st Dec 2011 - 6:39pm
TotalTwat's AvatarTotalTwat
Joined:
19 Jun 2011
Posts:
2
Location:
-
ProfilePM
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.