Results 1 to 6 of 6

calculating multiple payment types

Threaded View

  1. #6
    Forum Contributor
    Join Date
    05-16-2010
    Location
    UK
    MS-Off Ver
    2003 and 2007
    Posts
    252

    Re: calculating multiple payment types

    In the example workbook, with E3 formatted as a number, use this in E3 instead:

    =24*(IF(OR(A3="",B3=""),0,B3-A3)+IF(OR(C3="",D3=""),0,IF(24*C3<=3,0,IF(24*D3<=3,1-C3,D3-C3))))

    and drag down

    and with F3 formatted as a number, use this in F3 instead:

    =24*(IF(OR(C3="",D3=""),0,IF(24*D3>3,0,IF(24*C3<=3,D3-C3,D3))))

    and drag down

    EDIT:
    Assumes that the PM shift ends at 3am and that the PM shift could start from midnight. Change the times in the formula to suit your shift times.
    Attached Files Attached Files
    Last edited by pb71; 07-12-2010 at 03:15 PM. Reason: Workbook attached and comment added

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