cancel
Showing results for
Did you mean:
Helper III

## 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"

4 REPLIES 4
Helper III

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 III

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"

Announcements

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.