Results 1 to 4 of 4

converting time into amount via overtime pay

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    105

    converting time into amount via overtime pay

    Hello there!

    May I ask for assistance in solving my excel problem. This is regards to converting time into amount, this is used in computing overtime pay. In the attached file, Overtime is being categorized as follows:
    Regular (125%);
    ND-Night Diff (135%);
    WDO - Working Day-off (130%);
    WDO-OT -Working Day off OT (169%);
    Spl -Special OT (30%);
    Spl Ho OT - Special Holiday OT (169%);
    Legal (100%); and
    Lgl Ho OT - Legal Holiday OT (260%)

    This columns is categorized into Time distribution and amount distribution per Ot category. For the time distribution, I had some problems but due to urgency, my queries will be focusing in converting time ([h] mm) into amount (into single cell). Please see attached file for your reference.

    Thank you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 01-21-2016, 06:07 PM
  2. Payroll - Deduct one amount (overtime) from one or more totals
    By ThirtyTwo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-14-2014, 07:09 AM
  3. [SOLVED] Add an amount to wages if Overtime worked, but show zero if there is no overtime
    By KazzICC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-14-2014, 01:55 AM
  4. Replies: 5
    Last Post: 04-18-2013, 11:31 AM
  5. Converting a whole number into an amount of time
    By jimgatl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-07-2009, 03:41 AM
  6. [SOLVED] Converting time h:m to amount of time h.h%
    By Jenn in forum Excel General
    Replies: 2
    Last Post: 11-20-2005, 05:15 AM
  7. [SOLVED] Converting amount in figures to amount in words
    By Shrikant in forum Excel General
    Replies: 1
    Last Post: 08-16-2005, 06:05 AM

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