+ Reply to Thread
Results 1 to 6 of 6

How to calculate 1 hour is worth 1.175

Hybrid View

atlthiel How to calculate 1 hour is... 02-26-2008, 10:30 PM
robert111 enter as 21:30, 17:35 etc and... 02-27-2008, 05:04 AM
robert111 enter as 21:30, 17:35 etc and... 02-27-2008, 05:05 AM
atlthiel problem 02-27-2008, 08:56 AM
daddylonglegs As Robert says, enter your... 02-27-2008, 09:07 AM
atlthiel Thank you, it works like you... 02-27-2008, 05:08 PM
  1. #1
    Registered User
    Join Date
    02-26-2008
    Posts
    3

    How to calculate 1 hour is worth 1.175

    The example is I work 7:00pm to 9:30pm, I’m showing it as 1900 to 2130
    That is 2 hours and 30 min.
    This is what I have =(J2-I2)/100*1.125
    This isn’t working correctly but I don’t know how to calculate it to get the correct answer.
    Help

  2. #2
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690
    enter as 21:30, 17:35 etc and format the cell that subtracts them as a number with say 2 decimal places and you are on your way...

  3. #3
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690
    enter as 21:30, 17:35 etc and format the cell that subtracts them as a number with say 2 decimal places and you are on your way...

  4. #4
    Registered User
    Join Date
    02-26-2008
    Posts
    3

    problem

    It calculates 30 min as 30 not 50 (half of an hour)
    so the outcome is less.

  5. #5
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,677
    As Robert says, enter your times in a format excel recognises, i.e. with a colon like 19:00 and 21:30 then formula to give total earned is

    =MOD(J2-I2,1)*24*1.175

    where 1.175 is hourly rate

  6. #6
    Registered User
    Join Date
    02-26-2008
    Posts
    3

    Smile

    Thank you, it works like you said it would.
    Jerry

+ Reply to Thread

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