So I would like to convert a number, say "3" to a certain time & date based on 8:00 AM of the current day's date. So if it was 8:00 AM today (6/19/2013), the cell would say 8:00 AM 6/22/2013. Or if the number was 3.5, the cell would say 8:00 PM 6/22/2013.
Is this possible?
Hi,
Assuming you have the Date and Time in cell A1 in the format dd/mm/yyyy hh:mm and that your increment (e.g. 3) is in cell B1, enter this formula in C1: =A1+B1
Regards
That works, but how can I incorporate the 8:00 AM of the current days date as well?
You mean you want to have displayed in a cell e.g. 19/06/2013 08:00?
=TODAY()+TIMEVALUE("08:00")
Format cell as described above.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks