cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper V

## Convert Hours to Days and Minutes

Hi there

I'm trying to convert a duration total to Days, Hours and Minutes.

So for instance someone works 7 hours a day and over the course of a month has worked 560 hours. Im trying to covert 560 hours to X days, x hours, x minutes.

I just cant seem to do this and i'd be very grateful if someone could help me with this.

Many thanks

Karen

1 ACCEPTED SOLUTION
Solution Specialist

I see I made a mistake while converting the hours, also I didn't consider that your working day is 7 hours... please try this, it should work:

``````OverTime =
VAR OverTimeHours = [OverTimeHoursMeasure]
VAR Days = INT ( WorkingHours / 7 )
VAR Hours = INT ( WorkingHours - Days * 7 )
VAR Minutes = ROUND ( MOD ( WorkingHours, 1 )* 60 , 0)
RETURN
Days & " Days " & Hours & " Hours " & Minutes & " Minutes"``````

5 REPLIES 5
Helper V

Hi there

Thank you for getting back to me. Unfortunately, it doesnt quite work. Here's my result using your formula . Format 2 is your formula and Duration (h) is the number of hours they've done. So for instance Garden, Duration (h) =  32.50. So really they've worked 4 days 4 hours. Can you help with this please.

Thank you

Karen

Solution Specialist

I see I made a mistake while converting the hours, also I didn't consider that your working day is 7 hours... please try this, it should work:

``````OverTime =
VAR OverTimeHours = [OverTimeHoursMeasure]
VAR Days = INT ( WorkingHours / 7 )
VAR Hours = INT ( WorkingHours - Days * 7 )
VAR Minutes = ROUND ( MOD ( WorkingHours, 1 )* 60 , 0)
RETURN
Days & " Days " & Hours & " Hours " & Minutes & " Minutes"``````

Helper V

Thats brilliant thank you. Works a treat.

Kind regards

Karen

Solution Specialist

Try this (replace [OverTimeHoursMeasure] with the correct measure name):

``````OverTime =
VAR OverTimeHours = [OverTimeHoursMeasure]
VAR Days = INT ( WorkingHours / 24 )
VAR Hours = INT ( WorkingHours - INT ( WorkingHours / 24 ) )
VAR Minutes = ROUND ( MOD ( WorkingHours, 1 )* 60 , 0)
RETURN
Days & " Days " & Hours & " Hours " & Minutes & " Minutes"``````

Frequent Visitor

Thanks, I had a similar question and I figured it out using your proposed solution.