Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time format set from VBA
How do I go about setting the format of a cell to HH:MM from VBA?
I don't want the seconds showing. Just the Hour and Minutes. I have a program that is collecting data and I need to fill one of the fields with the time the data was taken. The worksheet is not setup ahead to pre-define the cell formats. I need to format the cell as I'm putting the time into it. Thanks for any help. Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time format set from VBA
Mike
Range("BlahBlah").NumberFormat = "hh:mm" Cells(lRow,ICol)NumberFormat = "hh:mm" HTH, Bernie MS Excel MVP "Mike" wrote in message ... How do I go about setting the format of a cell to HH:MM from VBA? I don't want the seconds showing. Just the Hour and Minutes. I have a program that is collecting data and I need to fill one of the fields with the time the data was taken. The worksheet is not setup ahead to pre-define the cell formats. I need to format the cell as I'm putting the time into it. Thanks for any help. Mike |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time format set from VBA
Thanks. I had checked in several places looking for just what you supplied
with no luck. Mike "Bernie Deitrick" wrote: Mike Range("BlahBlah").NumberFormat = "hh:mm" Cells(lRow,ICol)NumberFormat = "hh:mm" HTH, Bernie MS Excel MVP "Mike" wrote in message ... How do I go about setting the format of a cell to HH:MM from VBA? I don't want the seconds showing. Just the Hour and Minutes. I have a program that is collecting data and I need to fill one of the fields with the time the data was taken. The worksheet is not setup ahead to pre-define the cell formats. I need to format the cell as I'm putting the time into it. Thanks for any help. Mike |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time format set from VBA
Mike,
The macro recorder is your friend. It would give you this when you format a cell for time, hours and minutes: Selection.NumberFormat = "h:mm;@" which could be changed to Selection.NumberFormat = "h:mm" or Selection.NumberFormat = "hh:mm" and then you just usually need to change the Selection to a range object that you can use with your code so that you don't select anything. HTH, Bernie MS Excel MVP Thanks. I had checked in several places looking for just what you supplied with no luck. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Text to Time format of XX:XX | Excel Discussion (Misc queries) | |||
Adding Time Format | Excel Discussion (Misc queries) | |||
Adding Time Format | Excel Discussion (Misc queries) | |||
Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) | |||
Adding time | Excel Discussion (Misc queries) |