LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update Data Automatically Abdul Shakeel Excel Discussion (Misc queries) 0 March 20th 08 09:47 AM
How can I automatically update data on a certain day? Four-Eight Excel Discussion (Misc queries) 1 December 19th 07 05:52 AM
update data automatically Wu Excel Discussion (Misc queries) 1 November 30th 07 05:53 PM
Automatically Update Chart(s) with new data. Merlyn Charts and Charting in Excel 4 July 16th 07 07:18 PM
Can I set up the formula to update automatically? pugsly8422 Excel Worksheet Functions 1 March 23rd 05 04:43 PM


All times are GMT +1. The time now is 05:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"