Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format textbox to time
Need help on this one. How do I format a textbox, embeded in a userform, so
that when I type the hour 2130 it displays 21:30. -- ASU |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
format textbox to time
hi Asu
assuming that the 2130 is on the C8 =abs(left(c8,2)&":"&(right(c8,2)) format as 13:30:55 hope this helps regards from Brazil Marcelo "ASU" escreveu: Need help on this one. How do I format a textbox, embeded in a userform, so that when I type the hour 2130 it displays 21:30. -- ASU |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
format textbox to time
Hi ASU
What do you want entry 12 to be ? 00:12 or 12:00 ? And what about 12.5 ? Is it 12:30 or 12:50 ? (Believe me, your users will enter all kinds of crap so prepare for absolutely every possibility) Best wishes Harald "ASU" skrev i melding ... Need help on this one. How do I format a textbox, embeded in a userform, so that when I type the hour 2130 it displays 21:30. -- ASU |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
format textbox to time
Not quit what I was looking for. I`v got a userform with textboxes, two of
does textboxes I would be able to write a time, say 2130. And the textbox value comes up with 21:30. -- ASU "Marcelo" wrote: hi Asu assuming that the 2130 is on the C8 =abs(left(c8,2)&":"&(right(c8,2)) format as 13:30:55 hope this helps regards from Brazil Marcelo "ASU" escreveu: Need help on this one. How do I format a textbox, embeded in a userform, so that when I type the hour 2130 it displays 21:30. -- ASU |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Format | Excel Discussion (Misc queries) | |||
Time format set from VBA | Excel Discussion (Misc queries) | |||
Converting Text to Time format of XX:XX | 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) |