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