I
Ivano
Hi,
I am creating a spreadsheet to track the number of hours I work in a given
day then adding them up for the month.
Column A is my regular hours, column B I type in the actual hours I came in
and left that day, column C is the difference between my regular 8 hour shift
and the actual time I worked. I get into a problem when I get into negative
values. For example I am suppose to work 8 hours a day but if I leave early
or come in late by one hour I want it to show -1 under column C. The next
day I will come in one hour early and stay one hour late. So for the next
day column C will show 2. At the end of the month my net hours over/under
will be 1.
Regual Actual Time Over/Under
8:30 AM
4:30 PM
Total Over/Under = xxxx
I can't get the negative values to show right.
Thanks
I am creating a spreadsheet to track the number of hours I work in a given
day then adding them up for the month.
Column A is my regular hours, column B I type in the actual hours I came in
and left that day, column C is the difference between my regular 8 hour shift
and the actual time I worked. I get into a problem when I get into negative
values. For example I am suppose to work 8 hours a day but if I leave early
or come in late by one hour I want it to show -1 under column C. The next
day I will come in one hour early and stay one hour late. So for the next
day column C will show 2. At the end of the month my net hours over/under
will be 1.
Regual Actual Time Over/Under
8:30 AM
4:30 PM
Total Over/Under = xxxx
I can't get the negative values to show right.
Thanks