Closed Thread
Results 1 to 2 of 2

How to calculate a future year, month, day, hour, minute, second

  1. #1
    Registered User
    Join Date
    10-04-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    3

    How to calculate a future year, month, day, hour, minute, second

    My problem: I want excel to predict the position of a Moon of Jupiter in the future. For example, I know that on Tuesday, April 4, 2017, at 08 hour:12 minute:24 second the moon will be at it's greatest elongation. I also know that it takes the moon exactly 1.769 days to orbit and move back into that exact same position. I want to write a formula that will calculate the Day, Month, Year, Hour, Minute, second that the moon will be in that position next. So, I want to add 1.769 days to my starting date of Tuesday, April 4, 2017, at 08:12:24.

    I have looked at formula that creates a countdown timers and how to predict a future date in Excel, but I don't understand how I would extend that and put it all together to predict not only the day but the hour: minute: second.

    Can someone point me the correct direction?

    Thank you

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,410

    Re: How to calculate a future year, month, day, hour, minute, second

    Your original thread has been moved to the correct section and a solution offered there: https://www.excelforum.com/excel-for...ture-date.html
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Conditional Formatting based on calculated future dates (month only, ignore day and year)
    By Nitsirk82 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2014, 06:42 PM
  2. Replies: 1
    Last Post: 12-23-2013, 12:53 AM
  3. Converting four columns into unified hour-day-month-year value
    By Johanv91 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-03-2013, 11:47 AM
  4. Year-Month-Hour Counter
    By mycon73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2011, 11:20 AM
  5. Calculate future dates at 6 month intvls...?
    By ederoche in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-06-2007, 05:15 PM
  6. Picking the format year:month:day:hour:second?
    By flygarenbob in forum Excel General
    Replies: 1
    Last Post: 03-19-2007, 04:37 PM
  7. Convert Day, Month, Year, Hour into One Value
    By cb3291u in forum Excel General
    Replies: 3
    Last Post: 09-12-2006, 05:19 PM
  8. [SOLVED] convert time from 60 minute hour to 100 minute hour
    By Jboerding in forum Excel General
    Replies: 2
    Last Post: 07-06-2005, 06:30 PM

Tags for this Thread

Bookmarks

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