+ Reply to Thread
Results 1 to 2 of 2

calculate length of time

  1. #1
    Registered User
    Join Date
    02-11-2019
    Location
    Yorkshire
    MS-Off Ver
    16
    Posts
    1

    calculate length of time

    Afternoon all,

    I hope that you can help and I apologise if this has already been explained somewhere and I have just missed it.
    I need to be able to record the length of time it takes staff to pick up a document after it has been sent in.
    On the spreadsheet I have the time job has come in, the time the staff member has picked up the item, however I then need to be able to discount the hours between 16.00 and 08:00 and that is the part I am having trouble with. Especially as on an odd occasion it may take more than one day for the item to be picked up.

    Please can someone help with the formulae.

    Thank you

    Michelle x

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,601

    Re: calculate length of time

    It would help if you attached a sample Excel workbook, then we can see which columns you are using and if the times also include dates.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon, as this does not work on this forum.

    Hope this helps.

    Pete

+ 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] Calculate the Length of a Valley
    By LonnieLSmith in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-31-2015, 05:48 PM
  2. Calculate Lowest Value By The Length
    By sanju2323 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-21-2013, 10:50 AM
  3. Repeat Calculation At Length & Calculate Lowest Value At Length
    By sanju2323 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-17-2013, 09:19 AM
  4. [SOLVED] Macro or code to calculate the length of time a vehicle spends in a an area
    By AlexRoberts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2012, 01:56 AM
  5. Replies: 6
    Last Post: 02-06-2012, 12:25 PM
  6. [SOLVED] calculate length of employment
    By Mharper in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-29-2006, 11:55 AM
  7. Replies: 2
    Last Post: 03-15-2005, 04: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