How To Format a Cell as "[h]:mm" ????

[joshuaand]

Hi I am trying to format a cell as "[h]:mm" programatically using VB
but cant seem to do it.

I want to add up a bunch of hours, but by default it is setting th
format to "h:mm", which is NOT what I want.

anyones help is appreciated

 

[Rob van Gelder]

Range("A1").NumberFormat = "[h]:mm"

You need to learn the Macro Recorder. It's very useful for capturing these
sorts of things.

From Excel's menu, Tools | Macro | Record New Macro...
When you've finished, click the Stop button.

 

[JE McGimpsey]

This works for me:

ActiveCell.NumberFormat = "[h]:mm"

 

[Patrick Molloy]

Sub TestFormat()
SetFormat Range("C5:E10")
End Sub

Sub SetFormat(Target As Range)
Target.NumberFormat = "[H]:mm"
End Sub


Patrick Molloy
Microsoft Excel MVP