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
