Results 1 to 8 of 8

A formula to multiply hour and minutes to each rate?

Threaded View

  1. #1
    Registered User
    Join Date
    06-06-2013
    Location
    Manila
    MS-Off Ver
    Excel Mac 2011
    Posts
    8

    Lightbulb A formula to multiply hour and minutes to each rate?

    Let's say for example I have a work overtime of 1 hour and 15 minutes (1:15). For each overtime hour, the rate is $66.56, and for each overtime minute, the rate is $1.10 (The price is bit high because I'm using the value for my country, not the dollar rate).

    In this case, the solution would be (# of hours x 66.56) + (# of minutes x 1.1) = overtime pay. Thus, (1 x 66.56) + (15 x 1.1) = 83.06 (the overtime pay that I would be receiving).

    Is it possible to encode a formula in excel in this way? That if I input the hours and minutes of overtime, the specific cell would automatically solve like this?

    I hope someone can help me! Thank you!
    Last edited by mishxco; 06-06-2013 at 10:34 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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