Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"pb" wrote:
In your original post you just wanted something to convert a string. In follow-up postings it gets changed to a user input field. I ask because it you are convert existing text strings a second question comes to mind. What happens if the string includes seconds (ex: "01:23:45", "01:23:45pm")? What is to be done with them (displayed, ignored, round to the nearest minute)? -pb My users are not expected to enter seconds, such as "01:23:45" or "01:23:45pm". However, if someone does enter seconds, I would like to ignore the trailing seconds. So, "01:23:45pm" should be converted to "1323". |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert now (current date and time) to a string ddmmyyyyhhnn. | Excel Programming | |||
convert string to date & time | Excel Worksheet Functions | |||
Convert to Military time? | Excel Discussion (Misc queries) | |||
Function to convert Time String to Time | Excel Worksheet Functions | |||
Convert to military time - part II | Excel Programming |