# Convert number of days to specific time & date

1. ## Convert number of days to specific time & date

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?

2. ## Re: Convert number of days to specific time & date

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

3. ## Re: Convert number of days to specific time & date

That works, but how can I incorporate the 8:00 AM of the current days date as well?

4. ## Re: Convert number of days to specific time & date

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

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1