Forum Discussion
Calculate Timesheet Hours (duration) and display by month using stacked column graph
Hi, I'm working with timesheet data pulled from Clockify. They already push through the "Interval duration", which is the employees daily time captured in hh:nn:ss. So we don't have to work t...
Please see this article and video. It is best to format your durations as a decimal (in days), do your calculations, and then format it at the end to display it in the format you'd like.
Calculate and Format Durations in DAX – Hoosier BI
Pat
Hi ppm1, thank you. Will give that a try