| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Place a Dynamic Date + a Certain Time in a Cell
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Place a Dynamic Date + a Certain Time in a Cell
Dooh, just worked it out
=TODAY()+(630/1440) 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Place a Dynamic Date + a Certain Time in a Cell
=TODAY()+TIME(10,30,0)
Format the result apropriately (perhaps dd/mm/yy hh:mmAM/PM) -- David Biddulph "Sean" wrote in message ups.com... 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 |
|
#4
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
