Forum Discussion
Calculating Time power BI
Hi am trying to find a time calculation or formula
Current I have the following datasets
Finish time - Start time = Total hours
3:13:51 pm 11:52:13 am = 04:17:15 pm
I need to find total hours worked - without getting it been in a date/time format but rather the actual number of hours worked
in M add a custom column with this syntax
([Finish time]-[Start time])*24
in DAX
Column = (Table1[Finish time]-Table1[Start time])*24
1 Reply
- Stachu
Community Champion
in M add a custom column with this syntax
([Finish time]-[Start time])*24
in DAX
Column = (Table1[Finish time]-Table1[Start time])*24