Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 1

Accrual of hours

How do I create a formula that will accrue vacation hours on a monthly basis?
I've created a timesheet in excel version 2003. Each workbook contains a
bi-weekly timesheet. The last workbook is a YTD (year to date). I want to
add a formula that will show each month an employee accrued 1.66 days so I
can cross check what a person has used with what a person has accrued. Can
this be done?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
Vacation accrual Spreadsheet	TimBeau	Excel Discussion (Misc queries)	6	May 28th 08 03:40 PM
Vacation Accrual Formula Need Help Please!	trucker	Excel Worksheet Functions	0	June 8th 07 02:19 AM
Vacatio Accrual	AFroines	Excel Discussion (Misc queries)	3	March 16th 07 11:20 PM
Accrual Formula	Corey H.	Excel Worksheet Functions	3	January 30th 07 08:04 PM
Vacation accrual based on hours worked - Excel 2003	CCB AA	Excel Worksheet Functions	1	December 20th 05 08:39 PM

All times are GMT +1. The time now is 08:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us