View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Crist Crist is offline
external usenet poster
 
Posts: 9
Default 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!