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

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?

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

Hi,

Use SUM

Format the cell with the custom time formats such as [h]:mm:ss
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"lkpdata" wrote:

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?