You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
📰 Apple Fitness+ unveils an exciting lineup of new ways to stay active and mindful in 2025
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
Offerings include new programs for strength, pickleball, yoga, and breath meditation, and a new collaboration with Strava. Learn more >
What formula(s) do I need?
Current time formula =NOW()
Lets say this is in cell A1
Adding days is =A1+6. Now I am stuck and getting loads of "this isn't a date", "this isn't a time", "can't match datetimes" and other error messages.
I need to add 6 days, 21 hours and 9 minutes to the current time... Ideally, these values would be cells I can simply alter to meet my needs over time.
If you are in region where the word for day begins with "d" and the word for hour begins with "h" and the word for minute begins with "m" then you can simply write:
=A1+"6d21h9m"
If you will be entering different values in cells then you can use the DURATION function and refer to those cells, as in A7 in this example :
=A1+DURATION(weeks,A4,A5,A6)
Use ; instead of , in the formula if your region used , as the decimal separator.
More on DURATION here:
SG
Add a specific number of days hours and minutes to the current time
