+ Reply to Thread
Results 1 to 5 of 5

formula to add 30 secs onto time for every call made

  1. #1
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    429

    formula to add 30 secs onto time for every call made

    Guy's how do i get this to work out
    if my total worked is 5 hrs and ive made 60 outbound calls then i would like it so for every outbound call made there is a extra 30 sec added total worked hrs

    please see my attachmment for a clearer idea

    Dougers1
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: formula to add 30 secs onto time for every call made

    Try this in cell R4:

    Please Login or Register  to view this content.
    Will that work?

    Hope this helps!
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    429

    Re: formula to add 30 secs onto time for every call made

    Quote Originally Posted by mcmahobt View Post
    Try this in cell R4:

    Please Login or Register  to view this content.
    Will that work?

    Hope this helps!
    sorry my mistake i want it to add to total talk time and not worked time

  4. #4
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: formula to add 30 secs onto time for every call made

    Then does this work in cell M4?

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    11-26-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    429

    Re: formula to add 30 secs onto time for every call made

    Quote Originally Posted by mcmahobt View Post
    Then does this work in cell M4?

    Please Login or Register  to view this content.
    yeah thank you

+ 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. Replies: 5
    Last Post: 08-25-2014, 04:34 AM
  2. A call out time and a repair time formula
    By adammint7 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-24-2013, 11:46 AM
  3. Call made on time.
    By lifeskillscenter in forum Excel General
    Replies: 2
    Last Post: 05-05-2010, 03:36 PM
  4. How do I set cells to sum/average/etc time? e.g. 1 minute 30 secs
    By TavernerResearch in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2006, 09:20 PM
  5. [SOLVED] How can I calculate a value using time duration in mins & secs
    By michaeljohnking in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-16-2006, 10:40 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