Excel Hours Mins
July 21, 2006 7:12 AM Subscribe
Excel Filter: I need to convert a wallop load of cells that are in decimal format to hours & minutes format. Please. More Inside.
posted by kev23f to computers & internet (15 answers total)
I first thought this was a really obvious question, but its hot outside and i'm stumped. So, i've lots of cells with decimal data, but i need them in hrs and mins. So cell A with 2.30 in it, should be converted to Cell B with 2.50 in it. And so on for 2.25, 7.48, etc etc.
More importantly, i really need for this to be done with one formula.