Thank you for your reply Mandeep. This is a time log to log activities
with the 8 hour work day. So based on breaks and other tasks we
determined that 7.25 should be the amount of hours that the employees will
need to account for. There are times when the Time Logs are missing
hours...seems
Hi Lin,
Check the attachment and find the same Scenario as required !! One thing
which i didn't understand from where predetermined Total comes.(If I am
assuming it correctly You are trying to validate values from two different
sheets), Set this scenario in your sheet accordingly.
Regards,
Ma
