Results 1 to 2 of 2

Calculate money/hours between spesific time

Threaded View

  1. #1
    Registered User
    Join Date
    08-01-2010
    Location
    Netanya, Israel
    MS-Off Ver
    Excel 2007
    Posts
    6

    Calculate money/hours between spesific time

    I have an excel worksheet that calculates my hours into money but i also need help with applying a specific amount of money times (*) it by number of hours between the days Friday 18:30 - Saturday 18:30 (by 24 hours clock only).

    the pay is 31.5, pay per minute is 0.525!

    so for example, i worked from Friday 10:00 - 19:30, then i get 1 hour at 31.5, the rest isn't important because i have in my worksheet.
    and if its 55 minutes that i worked AFTER 18:30 then the pay is for 55 minutes (55*0.525)=28.875!

    i attached my worksheet file, so you can look at it.
    Attached Files Attached Files

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