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

L

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?
 
S

Shane Devenshire

Hi,

Use SUM

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I'm sure its an easy answer.... 1
Accrual of hours 0
Auto Merge text from multiple sources 0
Cells not updated automatically 3
Dumb question alert! What program to use? 0
Is there a function to count how many times a cells value is used? 0
Getting a formula to reflect added columns 10
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top