Results 1 to 7 of 7

Calculate rate of Pay

Threaded View

  1. #1
    Registered User
    Join Date
    02-05-2004
    Posts
    48

    Calculate rate of Pay

    Hope someone can assist.

    Looking for a formula that will calculate a different rate of pay based on time employee starts and finishes work.

    Two time rates of pay;

    8am/8pm - rate of pay 1
    8pm/8am - rate of pay 2

    I have attached a screen shot of the spreadsheet.

    Effectively I just need a formula to look at times in the START and END columns and calculate the appropriate formulas in the RATE 1 and RATE 2 columns.

    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1