Index/Match running slow

[yoshiredz]

I have a report that has shift information day on day for a month per person (there's over 1000 people, so lots of data).
Each individual shift is on a separate row (so 30 each)
I want to sort the data in a better way... for example - see below.
I have tried using - =FILTER('Shift Report'!$D:$D,('Shift Report'!$A:$A=Output!$A7)*('Shift Report'!$G:$G=Output!$AM$2)*('Shift Report'!$C:$C=Output!AM$5),0)
and also - =INDEX('Shift Report'!$D:$D,MATCH(1,('Shift Report'!$A:$A=Output!$A7)*('Shift Report'!$C:$C=Output!AO$5)*('Shift Report'!$G:$G=Output!AM$2),0))
as this uses the criteria of the name, date and week to insert the shift time.
problem is, it is taking a long time to calculate.
is there another way I can do this?
I do have some macros in the spreadsheet, which speeds up other things, but my knowledge doesn't stretch that far.
Any help is greatly appreciated
Thank you..

Mon

Tue

Wed

Thu

Name

Hours

10/10/2022

11/10/2022

12/10/2022

13/10/2022

Start

End

Start

End

Adams, Jen

25

08:30:00​

14:30:00​

08:30:00​

14:30

Adamson, Andrew

37​

10:00:00​

18:30:00​

10:00:00​

18:30

 

[Fluff]

Yes, see post#7

 

[yoshiredz]

Is there a better alternative that you would suggest?

sorry i missed the above! I will do that