topic Re: Convert Hours to Days and Minutes in DAX Commands and Tips

Convert Hours to Days and Minutes

KarenFingerhut — Sat, 31 Jul 2021 14:02:47 GMT

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

Re: Convert Hours to Days and Minutes

Mohammad_Refaei — Sat, 31 Jul 2021 16:55:01 GMT

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"

Re: Convert Hours to Days and Minutes

KarenFingerhut — Sun, 01 Aug 2021 08:19:31 GMT

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

Re: Convert Hours to Days and Minutes

Mohammad_Refaei — Sun, 01 Aug 2021 09:23:24 GMT

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"

Re: Convert Hours to Days and Minutes

KarenFingerhut — Sun, 01 Aug 2021 11:47:54 GMT

Thats brilliant thank you. Works a treat.

Kind regards

Karen

Re: Convert Hours to Days and Minutes

MXKCapgroup — Mon, 02 May 2022 20:39:04 GMT

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