YTD Log

Hello all,

I have this formula in C5 on 'YTD Log' sheet but it isn't working:

Formula:

Please Login or Register  to view this content.

I want to fill the hours for all EMPs from the 'Log' sheet please.

Does anyone know how to do this?

Thank you,
Billy

Hi!

Try this formula:
[C5] : =INDEX(Log!$G5:$CD5,MATCH(C$3,Log!$C$3:$BZ$3,))

Copy down and F, I, L columns (and so on). Blessings!

Thank you it works. I think I messed up the MIN formulas. Look at D52 it should be 40 and E52 should be 4:18.

Can you check please?

Hi, again!

The formulas are ok. Just:
1. Put 40:00 in B2
2. Change format for D and E columns (and so on) to [h]:mm

Blessings!

Great that works but why is it different on the Payroll sheet for regular hours?

Sorry I formatted to [h]:mm in both cells and it works thanks for the help.