If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|