Calculating Time power BI

[Anonymous]

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

[Stachu · Accepted solution]

in M add a custom column with this syntax

([Finish time]-[Start time])*24

in DAX

Column = (Table1[Finish time]-Table1[Start time])*24