| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Place a Dynamic Date + a Certain Time in a Cell
Try this:
=TODAY()+"10:30" Format cell as: dd/mm/yyyy h:mm "Sean" wrote: I might be stupid but I can't figure out how to return TODAY + a specified time in a Cell What I want to achieve is TODAYS date (this changes daily) and a specified Time. So for example I wish for today to show 06/01/07 10:30am; tomorrow will show 07/01/07 10:30am Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Click a cell and update to current time / date ? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | 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 Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Hybrid Mode
