Format cell
 

Hello,

How do I get Excel to display 10.5 as 10 h 1/2 and 7 as 7 h ?

Thanks for your help

Try the following format:

#" h" ?/?

Art

"Imanuel" wrote:

Hello,

How do I get Excel to display 10.5 as 10 h 1/2 and 7 as 7 h ?

Thanks for your help