+ Reply to Thread
Results 1 to 3 of 3

Total Mnutes Worked Showing Negative or Incorrect Value

  1. #1
    Registered User
    Join Date
    10-16-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2016
    Posts
    55

    Total Mnutes Worked Showing Negative or Incorrect Value

    I have 5 columns respectively; SalesPerson, Minutes Worked, Call Gaps, Minutes Deducted and Total Minutes Worked. Call Gaps column is subtracted from a salesperson's minutes worked. This should show in the Minutes Deducted column. The Total Minutes Worked should show either a 0 (ZERO) if the salesperson didn't work that day. If a salesperson reported only for 1 hour = 60 minutes then had a Call Gap of 10 minutes then his Total Minutes Worked should show as 50 minutes. The Minutes Deducted column should show as 430 (480 (complete shift) less 10 minutes (Call Gap)). Please help. Thank you in advance.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Total Mnutes Worked Showing Negative or Incorrect Value

    Try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    in E2 and copy down
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    10-16-2017
    Location
    PHILIPPINES
    MS-Off Ver
    2016
    Posts
    55

    Re: Total Mnutes Worked Showing Negative or Incorrect Value

    Thank you Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] pivot showing 0 in sub total row not negative value
    By wacky_diva in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-10-2015, 03:11 AM
  2. Basic Formula showing incorrect result
    By jane1613 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-01-2014, 06:50 PM
  3. Showing Incorrect Recent Files
    By mikejody in forum Excel General
    Replies: 4
    Last Post: 02-27-2014, 12:06 AM
  4. [SOLVED] PLEASE HELP!! Pivot table showing incorrect sums
    By illsonds in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-09-2013, 12:03 PM
  5. calender 12.0 control showing incorrect date
    By UAZHAR in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2013, 03:17 PM
  6. incorrect total showing up in cell
    By ibabs in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-30-2013, 06:31 PM
  7. Replies: 6
    Last Post: 05-03-2010, 12:03 PM

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