Forum Discussion
ThiagoDuarte
Helper I
Helper IAdd 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
- amitchandak
Super User
New column = [Start Date] + time(0,[Duration(Minute]), 0)
ThiagoDuarteit doesn't work
the column duration minutes have values over 3000
- Nathaniel_C
Community Champion
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
