Create error when timesheet dosn't add up?
Hi all, I'm trying to create a timesheet for a small business, templates that aren't easy to edit aren't fitting our needs anymore and it's asking me to self learn a lot of Excel, since the template we used to use didn't allow me to read the code functions it used.
Functionally, I can make it so if someone enters their shift start, and shift end, we get the total length of their shift (we pay through lunch). They can then allocate how many of those hours were spent on each rate (specific tasks or locations).
What I'm looking to do, is that, if the total in the green column is say, 6 hours, and someone only enters 5, or even 7 hours worth of tasks / rates, is there a way for the box to turn red, or some other form of error to be created to inform the person filling out the timesheet they have not added up their hours correctly?
[link] [comments]
Want to read more?
Check out the full article on the original site