You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

running total for overtime

Is there a formula for a running total of overtime hours? thanks!

Posted on Sep 15, 2021 7:07 AM

Reply
Question marked as Top-ranking reply

Posted on Sep 15, 2021 8:25 AM

There are ways to do this. Depending on what your table looks like you could use an "expanding range" something like this:




In C2, filled or copied down the column:


=SUM(B$2:B2)


If your table setup is different, then you could post a screenshot? (shift-command-4, select area on screen, release, then insert image (placed on the Desktop by default) into a new post here using the 'mountain' icon at the bottom of the compose window).


SG

4 replies
Question marked as Top-ranking reply

Sep 15, 2021 8:25 AM in response to hipp1

There are ways to do this. Depending on what your table looks like you could use an "expanding range" something like this:




In C2, filled or copied down the column:


=SUM(B$2:B2)


If your table setup is different, then you could post a screenshot? (shift-command-4, select area on screen, release, then insert image (placed on the Desktop by default) into a new post here using the 'mountain' icon at the bottom of the compose window).


SG

running total for overtime

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.