Forum Discussion
Solved
Add integer (minutes) to datetime
Hello guys,
I need to add an integer to a datetime to get the final date (date time format)
I have the start date column and the duration in minutes as an integer. I need datetime format as output (final date)
Any ideas on this?
Thanks,
Thiago
New Time1 = MAX('Table'[Time]) + MAX('Table'[Integers])/24/60Hi ThiagoDuarte Try this.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
11 Replies
New column = [Start Date] + time(0,[Duration(Minute]), 0)
it doesn't work
the column duration minutes have values over 3000
Hi ThiagoDuarte Try
[Time]+#duration(0,0,[Integers],0)
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
