+ Reply to Thread
Results 1 to 2 of 2

subtraction formula

  1. #1
    Registered User
    Join Date
    03-24-2006
    Posts
    21

    subtraction formula

    Hello

    I want to build one formula depending upon the number or working hours.

    In the sheet suppose i have following columns

    e.g

    Employee Name DateIn Timein DateOut Timeout Dept Shift Reg OT
    John 1/2/03 11:00 1/2/03 7:00 HR First 8:00


    So i want to write one formula in which if reg > 5 then automatically in Ot column it will subtract 8-5 and show OT as 3

    So how i should write formula?

  2. #2
    Registered User
    Join Date
    03-24-2006
    Posts
    21

    with if statement we can do it

    =IF(H7>$U$4,H7-$U$4,)

    H7 is the value where Reg column shows values. So if i want to extract extra hours then i should write above formula to solve this problem


    U4 is the total working hours

+ 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