Excel spreadsheet "Earned Sick Time Earned" formula help needed

Question

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...

Answer 1

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).