Time diff from different rows based on name e day (Hours worked)

Hi there,

I have to build a dax measures to calculate the worked time of each employee. The challenge here is that the data is saved by a sequence of input that the employee saves his timesheet in the MS forms.

I have the table below:

And I need to build a dax formula for the following requirements:

By employee:

• Hours worked today
• Hours worked this week
• Hours Worked from home

To achieve this I need the time diff from different rows, however, based on the employee name and the day.

Any way to achieve this easily in DAX without the need to change the structure of my table?

Thanks in advance.

Now the table to make easier the copy and paste