Results 1 to 2 of 2

Trouble with absolute values and hours/minutes and formulas

Threaded View

  1. #1
    Registered User
    Join Date
    07-27-2015
    Location
    Vancouver, BC
    MS-Off Ver
    Excel 2010
    Posts
    1

    Trouble with absolute values and hours/minutes and formulas

    I am trying to put together a spreadsheet with call times for our inside sales team. I cannot get the formulas to work and know I am doing something wrong with the formatting of the dates. What I am trying to do (and I will attach the spreadsheet below) is:

    Total talk time (right now is expressed as a number, which I know it shouldn't be) --so E4, should be hours and minutes, so 35 hours and 25 minutes

    Days this month is an absolute value, so $D$3 in this example

    subtract the days off and the meeting days off (so B4 and C4 together)

    What I've tried to do is =E4/($D$3-(B4+C4)) to figure out the average talk time.

    Does not work and I've tried a whole bunch of different formulations of it. I'm sure I don't have the duration time correct. Can anyone assist?

    Thanks,

    dglazer
    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. How to change the values to Minutes/ Hours
    By nitin_bidi in forum Excel General
    Replies: 7
    Last Post: 05-13-2015, 11:39 AM
  2. Convert Hours, day and week values in minutes
    By jonyorker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-02-2015, 03:28 PM
  3. Replies: 13
    Last Post: 05-03-2013, 08:42 PM
  4. [SOLVED] Trouble with adding hours and minutes
    By davekellar in forum Excel General
    Replies: 3
    Last Post: 04-27-2012, 07:37 PM
  5. [SOLVED] calculation with hours and minutes - input of negative values
    By MichaelMichael in forum Excel General
    Replies: 2
    Last Post: 07-10-2006, 01:49 PM
  6. Replies: 2
    Last Post: 05-25-2005, 12:06 PM
  7. add hours & minutes to other hours & minutes to receive total hou.
    By Wes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-01-2005, 08:06 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