| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Placing time with date
Oh Wise Ones,
We have a disposition file that records a date the entry was made among other things. I would like to add the time to that stamp. I know this is simple for you programmers but I need help with the syntax. Current code: Worksheets("Open Red Tags").Range("J4") = Date I would like to add the date AND time to J4, but preferably keep the formatting to display only the date (M/D/YYYY) . Could someone please help? Thanks, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting text format of time/date into Excel time/date for subtr | Excel Worksheet Functions | |||
| Calculating date and placing the value in the right date range col | Excel Discussion (Misc queries) | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
Threaded Mode
