Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - Error "Reference Is Not Valid" | Excel Discussion (Misc queries) | |||
I want to be able to input "Y" or "N" and tally them as 1 or 0. | Excel Worksheet Functions | |||
Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error | Excel Discussion (Misc queries) | |||
Odd "circular refference" error | Excel Discussion (Misc queries) |