ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Circular reference error when trying to keep a "running Tally" (https://www.excelbanter.com/excel-discussion-misc-queries/148006-circular-reference-error-when-trying-keep-running-tally.html)

Crist

Circular reference error when trying to keep a "running Tally"
 
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!


All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com