I know that as soon as I get some help with this I am going to kick myself because I should know this
On a work schedule I have a calculation that I do to calculate the hours worked. Just a simple =SUM(C19-B19) [Time out -time in] I then take this result to deduct a lunch break if necessary and add all of the hours together to make sure I am under payroll. The issue I am having is that when I write "OFF" or "VAC" to denote a day off of vacation day I get a #value since there is obviously no numbers there and I forget how to tell excel to ignore those cells without numbers
here is my set up
B19 C19 ...off to the side ... =SUM(C19-B19)
Time in Time out
So if I write off in either cell I get errors
Thanks
Bookmarks