Forum Discussion
Solved
Difference between two times
Hi everyone, I need to calculate the total minutes spent on working by each employee, by making the difference between a specific hour (08:30:00) and a column that contains the date and time they s...
Hi mtrevisiol ,
Try to create a new column like below:
Minutes of work = HOUR('Table'[dateend]- FORMAT('Table'[dateend],"YYYY-MM-DD 08:30:00"))*60Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi mtrevisiol ,
Try to create a new column like below:
Minutes of work = HOUR('Table'[dateend]- FORMAT('Table'[dateend],"YYYY-MM-DD 08:30:00"))*60
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.