Results 1 to 4 of 4

Timesheets with cost ie overtime, time & half

Threaded View

  1. #1
    Registered User
    Join Date
    10-18-2006
    Posts
    13

    Unhappy Timesheets with cost ie overtime, time & half

    Hellppp!!

    I'm doing up a timesheet which has got 3 columns. It contains "Ordinary Hours", "Time & Half" and "Double Time".

    I require a formula which calculates the cost automatically. If I put in 10 hours Mondays to Friday I need Excel to calculate 7.2hrs for Ordinary Hours eg $50, and 2 hours Time & Half $55 and 0.8 hrs $59 for Double time. I'll probably need one formula in a cell and the rest I'd probably be able to adopt the formula.

    On Saturday it's first 2 hours for Time & Half and 8 hours on Double Time.

    Would anyone be able to help me with this?

    Regards

    Euwest39
    Last edited by euwest30; 10-18-2006 at 04:03 AM.

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