Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm trying to add duration to start time in order to get the end time using the #duration () function, but seems it doesn't accept decimals as I understand the duration function does account the minutes and seconds 😁.
[StartDateTime]+#duration(0, [#"Duration (Hrs)"], 0, 0)
This is the result:
when Duration type is changed to whole number:
Is there a way to work around this? do I need to break the decimal hours to minutes and seconds???
Solved! Go to Solution.
Hi @Anonymous ,
Try this instead. It converts your decimal hours values to seconds before adding:
[StartDateTime] + #duration(0, 0, 0, [#"Duration (Hrs)"] * 3600)
Pete
Proud to be a Datanaut!
Hi @Anonymous ,
Try this instead. It converts your decimal hours values to seconds before adding:
[StartDateTime] + #duration(0, 0, 0, [#"Duration (Hrs)"] * 3600)
Pete
Proud to be a Datanaut!
No problem, happy to help.
Don't forget to give a thumbs-up on any posts that have helped you 👍
Pete
Proud to be a Datanaut!