View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike
 
Posts: n/a
Default 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