How to sum two durations stored in separate tables?

[ProverbialPaul]

Hello everyone

I'm sure this is an easy one but it's tripping me up.

I have two tables, both containing start and finish times and a power query calculated colum to work out the duration:

In each table, I have been using the following function to change the duration to an hour and min output:

Time taken =

VAR Elapsed_Time = SUM('Module Repairs'[Time taken - Duration])

VAR _hrs = (Elapsed_Time) * 24

VAR hrs = INT(_hrs)

VAR mins = ROUND((_hrs - hrs) * 60, 0)

RETURN

FORMAT(hrs,"00") & "h " & FORMAT(mins,"00") & "m "

I now want to sum the durations from both tables, apply the same function, and output a Total Time field.

In my brain, I thought I could just do this:

Total duration =

VAR Total_Time = SUM('Module Repairs'[Time taken - Duration]+'Travel Time'[Total travel duration])

VAR _hrs = (Total_Time) * 24

VAR hrs = INT(_hrs)

VAR mins = ROUND((_hrs - hrs) * 60, 0)

RETURN

FORMAT(hrs,"00") & "h " & FORMAT(mins,"00") & "m "

But it doesn't work.

Would somebody be able to point me in the right direction please?

Thanks team!

[ProverbialPaul]

@jdbuchanan71 

Of course it would be 🤦‍

Thank you good sir. I appreciate your help.

[jdbuchanan71 · Accepted solution]

@ProverbialPaul 

Try adding them after summing each like this.

VAR Total_Time = SUM('Module Repairs'[Time taken - Duration]) + SUM('Travel Time'[Total travel duration])
VAR _hrs = (Total_Time) * 24
VAR hrs = INT(_hrs)
VAR mins = ROUND((_hrs - hrs) * 60, 0)
RETURN
FORMAT(hrs,"00") & "h " & FORMAT(mins,"00") & "m "