Results 1 to 3 of 3

Formula to calculate minutes used in an interval

Threaded View

  1. 01-09-2014, 03:38 PM #1
    irascari
    irascari is offline
    Registered User
    Join Date
    02-20-2013
    Location
    Monterrey, Mexico
    MS-Off Ver
    Excel 2010
    Posts
    4

    Formula to calculate minutes used in an interval

    Hello

    I have tried to figure out how to write a formula to calculate how many minutes an agent have been in Open Time by interval

    Example if I have open time from 9:00-10:00 I need to calculate how many minutes were used from 9:00-9:30, from 9:30-10:00 and from 10:00-10:30

    Does any one have an idea what formula can I use?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. use of countif formula to calculate time intervals eg.15 min interval
    By sachin kokitkar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-25-2013, 10:32 AM
  2. [SOLVED] Need to identify the number of minutes that fit into a specific interval
    By Tameran31 in forum Excel General
    Replies: 2
    Last Post: 06-25-2012, 03:49 PM
  3. breaking a time interval in 5 to 5 minutes and displaying the name next to it
    By filtudor in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 09-10-2011, 05:31 PM
  4. Excel 2007 : Minutes and Hours (Interval Measurement)
    By Cdo in forum Excel General
    Replies: 2
    Last Post: 08-24-2010, 02:57 AM
  5. [SOLVED] Hours and minutes within/outside interval
    By Jan Kronsell in forum Excel General
    Replies: 15
    Last Post: 09-10-2005, 05:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1