Hi,
I want to put todays date + a time that is the same every day
If i use TODAY() then i get the date for today but at 00:00:00 o´clock
I want that the cell should take todays date and 08:00:00
Can someone help?
Hi,
I want to put todays date + a time that is the same every day
If i use TODAY() then i get the date for today but at 00:00:00 o´clock
I want that the cell should take todays date and 08:00:00
Can someone help?
Try...
=TEXT(TODAY(),"mmm d, yyyy")&" 08:00:00"
Adjust the formatting accordingly.
Hope this helps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks