time (in hours) per student - please advise

[Anonymous]

How do I make a visualization where Times duration is in hours instead of a text string?   
I need it to be an integer so I can total the hours for each Student.

Desired result looks like...

Blake: 2

Christianson: 4

[v-gizhi-msft · Accepted solution]

Hi,

According to your description, I create a table to test:

Please take following steps:

1)Use ‘Split Column’ function in Query Editor:

And it shows:

2)Then, add a custom column:

3)After Close&Apply, transfer column [TimeDuration] format to ‘Decimal number’:

4)Create a measure to calculate each student’s time duration:

TimeDuration of each student = CALCULATE(SUM('Table'[TimeDuration]),ALLEXCEPT('Table','Table'[Student Name]))

5)The result shows:

Here is my test pbix file:

pbix 

Best Regards,

Giotto Zhi

[Anonymous]

Hello Giotto,

Thank you for your time and effort. Great explanation, it helped!

[CoreyP]

I would open Query Editor, select your Times column and split by delimiter of " - ".

Rename the columns to start time and end time, respectively.

Then add a new column subtracting end time from start time.