Ask Experts Questions for FREE Help !
Ask
    rdiamond's Avatar
    rdiamond Posts: 2, Reputation: 1
    New Member
     
    #1

    May 1, 2009, 09:14 PM
    Require a formula
    I know I got paid $220 in 11:00 hours( I'm using the 24:00 format in the total time column.)
    And I know the answer is $20/hr, but what is the formula to calculate that hourly rate.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    May 1, 2009, 11:17 PM

    Since time is calculated as a 24th fraction of a day, you have to reverse that for reverse logic such as this.

    A1:
    $220.00

    B1:
    11:00 (11 hours 0 minutes)

    C1:
    =(A1/B1)/24
    rdiamond's Avatar
    rdiamond Posts: 2, Reputation: 1
    New Member
     
    #3

    May 2, 2009, 08:42 AM

    I'm using Microsoft office excel 2007, and I tried and this does not work in my spreadsheet.
    Zazonker's Avatar
    Zazonker Posts: 126, Reputation: 19
    -
     
    #4

    May 2, 2009, 12:06 PM
    You probably got the right answer but can't see it. Excel quite likely formated C1 for you in time format and your answer shows as 0:00. Change the format to currency and you should see $20.

    There are a number of additional issues when dealing with time in Excel. Just remember that to Excel, 11:00 means 11 am by default, not 11 hours of elapsed time.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #5

    May 2, 2009, 04:24 PM
    Quote Originally Posted by Zazonker View Post
    Just remember that to Excel, 11:00 means 11 am by
    default, not 11 hours of elapsed time.
    That's "sort of" correct. If you let Excel display a time value AS time, yes, it will display 11:00 as 11:00 AM, unless you override that display without the AM/PM.

    But you have to understand that TIME is actually calculated numerically as 1/24 of the number 1. That's why we multiply the actual numeric value by 24 to get a normal decimal.

    If you have a time of 12 noon in A1, click that cell and change the format to GENERAL you will see a value of .5 appear. 11:00 AM would show as .458333.

    So, multiply 11:00 AM (.458333) by 24 and the result is 11, an integer.

    Pretty cool once you get a hold of that logic. That's why my formula DOES work once the cell is formatted properly.

    Click the cell with my formula in it and press CTRL-1 to open the format cell box. Set the number format to general.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Does my Kid require SSN who is 2.5 years old? [ 1 Answers ]

Hi, I am on L1 and my 2 year 5 months old Kid is on L2.Do I need to apply SSN for my Kid for tax returns or do I need to apply for ITIN? Please advice ! Thanks Krishna

A movie name require [ 2 Answers ]

Hi There was one movie I saw 2 years back in which a human gets sick and all the processing inside his body was shown by animated machines. Machines process the food and medicine that boy takes. Life comes out of that boy inform of a animated character. In the last, that boy get saved by jumping...

Universities that do not require toefl [ 7 Answers ]

Us unversities that do not require toefl test?

Several Tools that require 220V [ 3 Answers ]

I have several Tools that require 220V. Problem is I only have one 220 receptical. Instead of having to disconnect tools all the time, I am wondering if there is a power strip available for 220V. ( only using 1 tool at the time!) Thanks


View more questions Search