Convert minutes into hours and minutes
Put quotes around min
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"lsbsed" wrote in message ...
| What if I want to display the converted hours and minutes as 25 h 20 min and
| not as 25:20? When I tried to format the cell as Custom [h] h mm min Excel
| though the first m of "min" meant minutes and displayed 25 h 20 20in. How to
| go around this and display neatly time with text abbreviations 25 h 20 min?
|