Undertime Vs Tardiness Vs Leaves and Present

Hi!

Hope you can help me here, I'm trying to create a formula for our attendance tracker.
Conditions are below;
If column K (Tardy) has a value, column M (Attendance) will be equal to the time the employee is tardy.
If column L (Undertime) has a value, column M (Attendance) will be equal to the time the employee is undertime
If both column K (Tardy) and column L (undertime) have values (digits), column K (Tardy) + column L (undertime)
then tagging VL, PL, ML, etc will be the else statements

I'm trying to do the IF(OR statement but having "#VALUE" result.

Thanks!
Please see attached for the same template.

Hi Bo,

It works!!! Thank you so much!!!
May I ask what is does * mean in ISNUMBER(VALUE)*ISNUMBER(VALUE) after the first if?
Does it mean it will multiply the 2 values?

Thanks!

Thank you so much for all the help!!