pdf Import Data Alignment Challenge

[Feastie]

Hi,

I have an import from a pdf that holds data on employee absence. I need to show just the employee and the total hours they have been absent, although this can be 1, 2 or more periods of absence.

What I need to see is simply:-

Employee 1 8.20 hours
Employee 2 18.45 hours
Employee 3 52.30 hours

The attached shows the current format.

pdf Import.xlsx

I would like a non macro solution if possible, please to create a template for another team member so the 3000+ records are easily manipulated on a weekly basis which then feed another system.

[Feastie]

Solved myself.

Think I was having a mental block. Is solved with a nested if. Looked at it one way when should've looked from the other!

[AliGW]

Thanks for letting us know.