Hello, would anyone know a formula to add a date with a time and bring the result of date and time updated?
example: Start date column: 6/7/2021 1:45 am Duration column: 0:45
Result column:
7/6/2021 2:30 pm.
Thanks in advance ! :blush:
Solved
Formula for adding a date to a time
+1Best answer by Kamille_Parks11
DATEADD(
{Start date},
{Duration},
'seconds'
)
+27DATEADD(
{Start date},
{Duration},
'seconds'
)
DATEADD(
{Start date},
{Duration},
'seconds'
)
Thank you for you suport Kamilleonarie. millions of likes for you :slightly_smiling_face:
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.