J
James Auty
I am wanting to show a text box with time [formatted
hh:mm:ss] that updates every minute based upon a
counter. I have used the timer function for this that
works fine. However, I am using DateAdd to increment
this textbox by a minute but the formatting goes directly
to AM/PM format reather than the preferred 24 hr format.
This value is then copied to a cell along with other
stuff, etc.
Is there another way I canformat the textbox to show only
hh:mm:ss? I have tried using the Forat function but this
just throws up an error
Thanks
James
hh:mm:ss] that updates every minute based upon a
counter. I have used the timer function for this that
works fine. However, I am using DateAdd to increment
this textbox by a minute but the formatting goes directly
to AM/PM format reather than the preferred 24 hr format.
This value is then copied to a cell along with other
stuff, etc.
Is there another way I canformat the textbox to show only
hh:mm:ss? I have tried using the Forat function but this
just throws up an error
Thanks
James