+ Reply to Thread
Results 1 to 5 of 5

Calculate out of service for a truck

  1. #1
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    310

    Calculate out of service for a truck

    Hi All,

    I am looking for a little help on this query expression below.
    I want to calculate the time in days it takes for repairs to be carried out on a truck.

    The Date_Down is the start of the time the truck was out of service.
    I have another field named Date_Up which is when the truck is back in service, so the below query expression will calculate the number of days the truck is down.

    So, how do I write the expression below to stop counting the number of days when I enter a date in Date_up field, I want to stop the time.

    Please Login or Register  to view this content.
    Thanks
    ==========
    Bigroo1958
    Austin, Texas
    ==========

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007
    Posts
    2,275

    Re: Calculate out of service for a truck

    Assuming you have the dates in different cells of your spreadsheet and using an example of:

    Start Date A1

    End Date B1

    Total Days C1

    Paste in the formula bar for C1 :
    Please Login or Register  to view this content.

    Format A1 & B1 as : dd-mmm-yy
    Format C1 as number, no decimals
    Cats. Because People Suck.

    If someone has assisted you in any way, please be respectful to acknowledge it.
    Simply saying "Thank you" will suffice. If you are so moved, adding to their reputation by clicking
    <------ Add Reputation is a very nice gesture.
    When your question has been answered, Please mark the thread as SOLVED.

  3. #3
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    310

    Re: Calculate out of service for a truck

    Thanks for your reply, but this is an Access database not an Excel spreadsheet!!

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    2007
    Posts
    2,275

    Re: Calculate out of service for a truck

    Well darn ! Haven't used Access in years.

    So sorry.

  5. #5
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    3,124

    Re: Calculate out of service for a truck

    I'm not sure I have understood 100% but perhaps something like:
    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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