Calculate time difference with respect to Date and given time in decimal format

[mohsin-raza]

Hello:

I tried to calculate tworking hours with the rest time given in decimal format with 1 = 60 min and .75=.75*60=45 min and again one emplyee starts work one day AM and another day with AM( mark with yellow colour). I got wrong result in my measure . Can some body help me to solve this problem?

here is the sample dataset:

Regards: 

[mohsin-raza · Accepted solution]

I tried again and find the solution like 

Step1: Calculated the time difference in times by using function DATEDIFF and VALUES

min = DATEDIFF(VALUES(Table[TimeReportStart]),VALUES(Table[TimeReportEnd]),MINUTE)

Step 2: Multiple Hours with 60 to calculate time in mintes

Rest = sum(Table[BreakHours])*60

Step3 : Find the difference of minutes

diff=[min]-[Rest]

Step 4 : Convert the times in min into hour:min with following formula 

Working Hours=

var hourNo=INT([diff]/60)

var minuteNO=MOD([diff],60)

return

FORMAT(hourNo,"#00")&":"&FORMAT(minuteNO,"#00")

Hope this will solve same types of problem 😊