Excel spreadsheet "Earned Sick Time Earned" formula help needed

Accounting 20

Hello,

I am a beginner at Excel. I am trying to create a spreadsheet to track Sick Time Earned.

1 hour earned for 30 hours worked. I need help completing this spreadsheet. What formula can I use to automatically calculate for column G and H (sick time used and sick time available)?

THANK YOU... Screenshot 2025-02-17 at 10.39.52 AM

Screenshot 2025-02-17 at 3.27.01 PM

Accepted answer

Barry Schwarz 3,491 Reputation points

2025-02-18T22:42:40.67+00:00

There is no formula for sick time used in column G. You have to enter the time as it is used.

Sick time available can be calculated as the difference between the time accrued and the total amount previously taken. In H4, enter the formula =F4-SUM(G$4:G4). Then copy this cell to H5 through the bottom of your data. This will cause the reference to F4 to access the current row's data and the sum function to calculate the total number hours used to date. For example, cell H5 will contain =F5-SUM(G$4:G5).
Please sign in to rate this answer.

1 person found this answer helpful.
Jiajing Hua-MFST 14,885 Reputation points Microsoft Vendor

2025-02-19T05:58:52.4366667+00:00

Hi @Accounting

If you have a chance to be back, please refer to Barry Schwarz's suggestion.

Any further issues, welcome to post back.

Accounting 20 Reputation points

2025-02-19T16:38:15.85+00:00

Hello Barry,

Thank you so much. This worked perfectly! I much appreciate the time and effort you took to answer my question.

Accounting 20 Reputation points

2025-02-19T16:40:53.0666667+00:00

Thank you Barry. This worked perfectly! I much appreciate your time and expertise in answering my question.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Excel spreadsheet "Earned Sick Time Earned" formula help needed

0 additional answers

Your answer