C
CrisT
Hello, I have a spreadsheet that I am to keep track of how much time I work
per day. I have a colum that totals the hours for the day, and a Column that
shows me overtime or time that I have to make up based on an 8 hour day.
What I would like, would be to keep a running tally of the extra or possible
make up time in the "Balance to make up " column. I have searched this forum
about the negative time issue and currently do not have that issue, I also do
not use the 1904 date system.
A B C
Hours Worked Difference in Hours Balance to make up
1 8:00:00 0:00:00
2 5:00:00 -3:00:00
3 9:00:00 1:00:00
4 8:30:00 0:30:00
5 8:30:00 0:30:00
6 8:00:00 0:00:00
What kind of formula would I need to keep a running tally that would be in
time format and show negative hours/minutes?
Thanks in advance for any help!
per day. I have a colum that totals the hours for the day, and a Column that
shows me overtime or time that I have to make up based on an 8 hour day.
What I would like, would be to keep a running tally of the extra or possible
make up time in the "Balance to make up " column. I have searched this forum
about the negative time issue and currently do not have that issue, I also do
not use the 1904 date system.
A B C
Hours Worked Difference in Hours Balance to make up
1 8:00:00 0:00:00
2 5:00:00 -3:00:00
3 9:00:00 1:00:00
4 8:30:00 0:30:00
5 8:30:00 0:30:00
6 8:00:00 0:00:00
What kind of formula would I need to keep a running tally that would be in
time format and show negative hours/minutes?
Thanks in advance for any help!