Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default time card program

Hi,
I created a time card program and need some advice on how to calc ot...
any HR progammers out there???

If 1.5 is paid for all hours after 8 and all hours after 40 then...
if a person works 9 hours on monday (1 hr ot ( @1.5)) and 8 hours Tues
through Fri, then the
last hour on Friday is their 41 hour. Does that hour ALSO get paid as
ot )? This would
show on his time sheet as 41 hours worked with 2 hours at 1.5. The 9th
hour on Monday
(any hours over 8 in a day) and the 8th hour on Friday (any hour over
40 worked in a week).


thanks,

peter

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 129
Default time card program

Peter,

I am not an HR programmer, but I manage a staff in a Union shop.
Overtime is considered for any hours worked beyond a scheduled shift in
a given day regardless of how many hours are completed for the week.
Somebody working 10 hours today, but only completing 30 hours for the
week, would get 2 hours o/t for the week.

Some shops only pay overtime if total hours logged for the week exceed
40, etc. So, the 2 hours would be regular time for the 30 hour person.

Alan

pande wrote:
Hi,
I created a time card program and need some advice on how to calc ot...
any HR progammers out there???

If 1.5 is paid for all hours after 8 and all hours after 40 then...
if a person works 9 hours on monday (1 hr ot ( @1.5)) and 8 hours Tues
through Fri, then the
last hour on Friday is their 41 hour. Does that hour ALSO get paid as
ot )? This would
show on his time sheet as 41 hours worked with 2 hours at 1.5. The 9th
hour on Monday
(any hours over 8 in a day) and the 8th hour on Friday (any hour over
40 worked in a week).


thanks,

peter


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
recipe card program Donna New Users to Excel 1 February 16th 07 11:20 PM
New Time Card OSSIE Excel Discussion (Misc queries) 3 March 21st 06 02:17 AM
Time Card OSSIE Excel Discussion (Misc queries) 1 March 17th 06 10:02 PM
Time Card Dan B Excel Worksheet Functions 2 March 23rd 05 08:25 PM
Help with Card Program Tom Ogilvy Excel Programming 0 August 9th 03 07:59 PM


All times are GMT +1. The time now is 12:26 AM.

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

About Us

"It's about Microsoft Excel"