Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 410
Default Formula for calculating time off

On Mar 14, 9:17*am, jlclyde wrote:
On Mar 14, 8:14*am, "Bob Phillips" wrote:



I have to point this out, so apologies if it sounds pedantic, but it is
accrue, accrual, accruing.


I think we are missing the details, but here are some questions.


Do you want to calculate from a start date or have you worked out the years
and week from that start date already?


I assume that 1.538461538 is the weekly increment


What about part weeks? What about if they start part way through a week?


--
---
HTH


Bob


Bob,
First of all I am sorry for the terrible spelling. *Secondly, There
are 2 start dates. *There is going to be the persons start date with
the company and the second start date is going to be the 1st of June.
June is when we are going to start the program. *So we need to know
the number of years that a person worked so that they are accruing at
the right rate.

You are correct to assume that the 1.53 number is the weekly accrual
rate.
If a person starts in the middle of the week the person accrues the
full amount for the week. *The accruals go in on Sundays.

Thanks for your time,
Jay- Hide quoted text -

- Show quoted text -


I was wondering if anyone had thought about this over the weekend and
came up with something terrific. I thought about it but had gotten no
where.
Jay
Reply
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
calculating timesheet, time-in/time-out = total hours & minutes, . Steve Lindsay Excel Worksheet Functions 13 November 8th 06 03:45 PM
time calculating formula ssalam Excel Worksheet Functions 2 August 6th 06 05:43 PM
I need help with a formula calculating time Mark Excel Discussion (Misc queries) 2 April 27th 05 10:31 AM
Formula for calculating time kc sunshine Excel Worksheet Functions 2 April 26th 05 08:38 PM
Calculating effective time from start/end date+time Stefan Stridh Excel Worksheet Functions 8 November 27th 04 03:50 PM


All times are GMT +1. The time now is 01:11 PM.

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"