Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table - Error "Reference Is Not Valid" Olly Excel Discussion (Misc queries) 0 May 22nd 07 09:27 AM
I want to be able to input "Y" or "N" and tally them as 1 or 0. lia Excel Worksheet Functions 4 March 6th 07 07:51 PM
Shortcut key for "Paste Options" and "Error Checking" buttons? johndog Excel Discussion (Misc queries) 1 October 6th 06 11:56 AM
Macro to Create New Worksheet and Reference Cell in Old Worksheet As Tab Name - "Object Required" Error [email protected] Excel Discussion (Misc queries) 4 September 25th 06 01:35 PM
Odd "circular refference" error Jerry W. Lewis Excel Discussion (Misc queries) 0 May 1st 06 06:10 PM


All times are GMT +1. The time now is 06:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"