| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble formatting a date variable to contain a time value
In the immediate window, type
?Format(1510,"00\:00") then ?TimeValue(Format(1510,"00\:00")) In article , Arch Stanton wrote: If I could ask one more thing, what does the slash in the format string ("00\:00") do? I can't find it in VBA Help, but it seems to work. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trouble formatting date | Excel Worksheet Functions | |||
| Trouble formatting Date data | Charts and Charting in Excel | |||
| Trouble with OpenText() and Date/Time Values | Excel Programming | |||
| Put only date (not time too) in variable from FileDateTime function | Excel Programming | |||
| Trouble setting variable as filename with date | Excel Programming | |||
Threaded Mode
