Format for hours

[MakezHD]

I want to introduce a number with COMMAS for decimals and I want excel to add "hours".

For example, if I introduce 6 in a cell I want to see 6 hours or 6,00 hours, I don't care. Or if I introduce 6,43 I want to see 6,43 hours.

Which format should I use to get that? Thanks!

 

[sandy666]

maybe custom format: #.### "hours"

but 1 will be as 1 hours and 6 as 6 hours

 

[Vbagreenhorn1]

this works for me:

 #.##0,00 "hours"

 

[JoeMo]

Try this custom format:
@" Hours"

 

[MakezHD]

maybe custom format: #.### "hours"

but 1 will be as 1 hours and 6 as 6 hours

I need it to be with commas, I mean, 5/2 is 2,5 not 2.5

this works for me:

 #.##0,00 "hours"

Not working for me, maybe because my Windows is set up to place , instead of . for decimals?

Try this custom format:
@" Hours"

Hours not showing up

 

[sandy666]

so try custom format #,### "hours"

 

[Rick Rothstein]

I need it to be with commas, I mean, 5/2 is 2,5 not 2.5
Not working for me, maybe because my Windows is set up to place , instead of . for decimals?

Does this Custom Format work for you...

[=1]# "hour";#.## "hours"

Note: While a value of 1 is displayed as "1 hour", any other whole number of hours will be displayed with a decimal point (hopefully, the decimal point will be a comma on your system); so, a value of 2 will be displayed as "2. hours" (I don't know how to suppress the decimal point in a Custom Format, but I do know how to do it using VB event code).

 

[JoeMo]

If "hours" is not showing up with the custom format @" Hours" try copying the bold, red part of this sentence and paste it into the custom format box.