Hello EXCEL Gurus. I need to add a hardcoded TIME (military) to the end of a DATE formula in a specific range of cells in Col A.
The current formula in these cells is: =TODAY()-WEEKDAY(TODAY(),3)+IF(WEEKDAY(TODAY(),3)>4,11,4)
I would like the end result to be: 06/19/2015 13:00.
The Time will be different in each cell and will serve as a guide and also be used for sorting purposes.
Any advice would be greatly appreciated!
=yourFormula + "13:00"
Entia non sunt multiplicanda sine necessitate
you just have to add a fraction of a day (like 1/24) to your actual formula. The fraction of a day will show up a the time. You'll have to change the cells' format though.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
What do you mean the time will be different in each cell?
If you wanted to hard code the time into the formula you posted you could use this,
and format the cell with the formula with this - mm/dd/yyyy hh:mm.HTML Code:
Last edited by Norie; 06-16-2015 at 06:43 PM. Reason: Formula tags don't seem to like < or maybes it's >
If posting code please use code tags, see here.
Thank You shg, p24leclerc, & Norie - You guys rock!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks