View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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?