Is there a formula that will allow data to automatically update?

[lkpdata]

I have a spreadsheet that I update on a weekly basis. I have it set up with
formulas so when I add in accrued sick leave/vacation leave time in a cell,
another cell to the left shows the total available time. What I would like
to know is: Is there a formula I can put into a cell that will automatically
add in the accrued time each week?

 

[Shane Devenshire]

Hi,

Use SUM

Format the cell with the custom time formats such as [h]:mm:ss