How to store global date time and convert it to local date time?

Date and time

• QUESTION: I have littleexprience and would like to enter a date and time in one cell and have the next cell represent a the first cells date and time + 20 hrs. I know it is probably very simple, but I'm lost. ANSWER: CJ The formula to add 20 hours to a cell with a time in it is =A1 plus 20/24 since time is a fraction of a day, and 20 hours would be 20/24 of a day. The formula above assumes your time to be incremented is in cell A1. You can put the current time in a cell with =now() or just entering control and colon (crtl:) at the same time. ---------- FOLLOW-UP ---------- QUESTION: I tried what you recommended...two things, 1. What is the formula for a specific (future) date and time not the current D&T. 2. When I entered the current D&T i.e. =now() and then entered =A1 plus 20/24 it didn't give me a time just the next day.

• Answer:

  CJ I believe you just have a cell format issue. Format the cell with the formula that adds 20/24 to display the date and time, or just the time and it should be okay. As for the formula for a specific future date, that depends on the future date. counts the days since 1900 for the date. If yo enter 40415 and display it as a date, it will show today. If you enter 40415.8 and display date and time, it will show today at 8:00 pm. 40416 will be tomorrow.