Making a time sheet that includes shift differentials and overtime differentials. In the attached example, how do I make cell H15 = 0 when H3 = 0? For instance:
=SUM(H3-H6)
Making a time sheet that includes shift differentials and overtime differentials. In the attached example, how do I make cell H15 = 0 when H3 = 0? For instance:
=SUM(H3-H6)
Last edited by jonvanwyk; 06-29-2010 at 11:48 AM.
Hard to follow since you posted a jpg instead of an excel file but maybe
=MAX(0,H3-H6)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I didn't post the spreadsheet because much of it is quite unorthodox and I hate being made fun of. H3-H6 is actually N37-N44 as I have many merged cells and it can look quite confusing. I had to make the spreadsheet look exactly like the printed/hand written form of the current timesheet. This made it MUCH more difficult to make everything work. But, people generally do not like change, so if you want to get an electronic timesheet passed through administration, you have to change everyone's lives as little as possible (understandably).
BTW...your suggestion worked. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks