Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Page 1 of 2 1 2 LastLast
Results 1 to 10 of 12

Thread: calculate earnings from time worked x hourly rate

  1. #1
    Join Date
    18th April 2006
    Posts
    1

    calculate earnings from time worked x hourly rate

    I am trying to calculate earnings based upon hours worked based on 24 hours format (time out - time in = time worked) multiplied by hourly rate. I cannot get the proper calculation. How can I attach a copy of the Excel worksheet?
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Last edited by hduff; April 18th, 2006 at 06:57.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,039

    Re: calculate earnings from time worked x hourly rate

    Hi Hduff,

    welcome to the OzGrid forum!

    If you attach a small example sheet, I will (try to) put in the formula needed.

    Wigi

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    27th January 2003
    Location
    Montana
    Posts
    204

    Re: calculate earnings from time worked x hourly rate

    In time in A1 as 24 hr format
    Out time in B1 as 24 hr format

    =(B1-A1)*24*HourlyRate

    See http://www.cpearson.com/excel/datetime.htm#AddingDates

    lenze

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    31st January 2006
    Posts
    56

    Re: calculate earnings from time worked x hourly rate

    See if this is what you are after.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    20th November 2006
    Posts
    3

    Re: calculate earnings from time worked x hourly rate

    Hi Guys

    This is my first post so please be gentle (hope I've posted in the right place!)

    I'm trying to work out a spreadsheet for my earnings from one of my jobs. I got some great info from the above post but what I'm struggling on now is how to overcome the "working till midnight" issue. My spreadsheet calculates that if I've worked from 17:00 to 00:00 I've worked minus 17 hours? How can I overcome this?

    I've attached my spreadsheet for you to dissect : D

    in advance

    Nikki

    Library Theatre Hours_Earnings.xls
    Last edited by dzdoris; November 20th, 2006 at 22:39.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    3rd October 2006
    Location
    Cardiff, UK
    Posts
    263

    Re: calculate earnings from time worked x hourly rate

    Well, the simplest way would be to put in 24:00 instead of 00:00 (it is, after all, a 24hr clock). It then shows as 7hrs.

    HTH

    KJ

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    20th November 2006
    Posts
    3

    Re: calculate earnings from time worked x hourly rate

    Awww thanks KJ - why didn't I think of that???

    Nikki

    P.S. Great site, only just come across it! Could have done with this years ago!!

    Excel Video Tutorials / Excel Dashboards Reports


  8. #8
    Join Date
    3rd October 2006
    Location
    Cardiff, UK
    Posts
    263

    Re: calculate earnings from time worked x hourly rate

    No problem.

    The amount of times i've wracked my brain for hours trying to solve problems in a convoluted way only to post here and a helpful soul bring me back to earth with a simple solution.

    This forum is a life-saver.

    KJ

    Excel Video Tutorials / Excel Dashboards Reports


  9. #9
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: calculate earnings from time worked x hourly rate

    dzdoris, Glad you got what you wanted, but we have a rule on here that you must not hijack a post - you start your own. (You did read the rules did you?)

    Excel Video Tutorials / Excel Dashboards Reports


  10. #10
    Join Date
    20th November 2006
    Posts
    3

    Re: calculate earnings from time worked x hourly rate

    So sorry

    I did sort of whizz through them and then after I posted read them properly, realised my mistake and PM'd Dave Hawley to apologise

    It just seems that this forum does exactly what all the others ask you not to i.e. start a post when there's already one for what you're asking??

    I've learnt from my mistake and promise it won't happen again!

    Nikki

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Hourly Rate Divided By Total Time
    By chew in forum EXCEL HELP
    Replies: 6
    Last Post: March 8th, 2008, 06:06
  2. Calculate Hours Worked After Specific Time
    By needhelp2008 in forum EXCEL HELP
    Replies: 11
    Last Post: February 10th, 2008, 13:49
  3. Calculate Accrued Vacation Based On Time Worked
    By bmckune in forum EXCEL HELP
    Replies: 1
    Last Post: February 3rd, 2008, 13:52
  4. Calculate Total Time Worked. Decimal Times
    By redbubble in forum EXCEL HELP
    Replies: 8
    Last Post: August 15th, 2007, 06:13
  5. Calculating Hourly Pay Rate
    By mudraker in forum Excel and/or Access Help
    Replies: 2
    Last Post: July 9th, 2007, 16:04

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
  •  
porno