- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 01, 2024 12:13 AM
I have a date+time and a duration (days: hours: minutes). I want to add a day:hour:minute duration to the date+time and output a new date+time. Issues I've encountered:
1. I can only set a duration field to be day OR hours/minutes/seconds.
2. When attempting to create a formula to add a "Day" duration field to a "Hour" duration field the output is incorrect. For example I have a Day Duration field with "1" and in the Hour duration field I have 00:05. I tried
I just want to recreate the function of this form under "Add or subtract time from a date" https://www.calculator.net/time-calculator.html?today2=07%2F31%2F2024&today2hour=6&today2min=15&toda...
I thought this would be more simple than it is. Any help would be appreciated.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 01, 2024 06:29 PM
Hmm, I think you're going to need to have one field for days and one field for hours/minutes/seconds I'm afraid
DATEADD(
DATEADD(
Date,
Days,
'days'
),
{Hours/Minutes/Seconds},
'seconds'
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 01, 2024 06:29 PM
Hmm, I think you're going to need to have one field for days and one field for hours/minutes/seconds I'm afraid
DATEADD(
DATEADD(
Date,
Days,
'days'
),
{Hours/Minutes/Seconds},
'seconds'
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 02, 2024 06:14 PM
Thank you! This is perfect. It worked exactly as I needed.
