Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Wink I need a lot of help with MS Excel 2010

I am trying to do a tracking sheet that will automatically calculate the totals for me. I get pd. Bi-Weekly @ 18.29 per hr. I also get a shift differential of .72 per hour for shifts between 4 pm and 7 am. I get a weekend differential as well of 1.25 per hour for weekend shifts between Saturday 12 am to Monday 12 am. Overtime is calculated at 1.5 and holiday shifts are double time.

During evening shifts and overnight shifts i get paid breaks (2 @ 15 minutes) and supper (1/2 hour).

I downloaded a template and tried playing around with it but i just can't make sense of the formula's.

Here is a link of what i have done so far.

file:///C:/Users/Marg/Documents/MY%20NEW%20PAYROLL%20TRACKER%20FOR%20EXCEL%202010. htm

I hope someone can help me , i have no clue what to do now that i have put in some of my own information on the template. My payroll from work has been wrong this past 2 pay periods and that is why i decided maybe i can keep track also.

Thanks in advance for any help and i hope the link above works.

Marg Jackman

Last edited by Lambshots : March 12th 13 at 03:58 PM Reason: Not sure about the link working
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 277
Default I need a lot of help with MS Excel 2010

On Fri, 8 Mar 2013 01:49:35 +0000, Lambshots
wrote:

During evening shifts and overnight shifts i get paid breaks (2 @ 15
minutes) and supper (1/2 hour).



In the US, ALL hourly workers get a 15 minute break after each two
hour work session. They are always ON THE CLOCK.

The lunch period is NOT on the clock.

This is from the US Labor Relations Board.

Most states pay for any OT that is beyond 8 hours in a single day, and
that at 1.5 times the base rate. Some convolute it to pay only those
hours that are greater than 40 in a week.

So, in a 'normal', 'complete' "40 hour week", that would make any
weekend work as OT automatically.

The double rate polices are usually per company or per contract or per
organization.

You should post the link for the original template you used.

The 'link" you posted to your "file" will not work, as you would need
to upload the file to some web based file hosting place first and then
post that link.
  #3   Report Post  
Junior Member
 
Posts: 2
Red face

Here is the original Time Sheet i was using. I saved it as a ZIP File so i could upload it here. The shifts i work with Eastern Health, Government Employee is a 35 hr week and during the day shift there are 2 paid breaks in the 7.5 hour day and 1/2 hr unpaid dinner.

During an evening shift the 2 - 15 minute breaks are paid as well as the supper break (1/2 hr) because there is no one to relieve you as you are working this shift alone. The overnight shift is all paid breaks 15 + 15 +1/2 hr.

Thank you for your help


[quote=CellShocked;1610163]On Fri, 8 Mar 2013 01:49:35 +0000, Lambshots
wrote:

During evening shifts and overnight shifts i get paid breaks (2 @ 15
minutes) and supper (1/2 hour).

QUOTE]
Attached Files
File Type: zip Date and Time Functions.zip (23.4 KB, 18 views)

Last edited by Lambshots : March 12th 13 at 01:52 AM
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
Excel 2010 to auto-generate an email to recipients in outlook 2010 dmcmillo Excel Programming 0 June 14th 12 10:12 PM
Alt-F8 and Excel 2010 Tim Childs[_5_] Excel Programming 4 August 25th 11 11:12 AM
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM Peter Gonzalez[_2_] Excel Worksheet Functions 2 January 26th 10 07:58 PM
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3 Darrell[_2_] Excel Programming 0 January 12th 10 09:53 PM


All times are GMT +1. The time now is 02:14 PM.

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"