+ Reply to Thread
Results 1 to 2 of 2

how do i build the macro i need?

  1. #1
    Stuart
    Guest

    how do i build the macro i need?

    i work for an accident management company part of what we do for our fleet
    customers is provide them with reports. in these reports we have a column in
    an excel spreadsheet called downtime this uses the formulae =sum(H2-F2) where
    column H is date vehicle was returned and column F is date vehicle came
    onsite the answer is displayed as an integer value in the downtime column.

    however if onsite date is entered but no return date, or date returned
    entered without an onsite date or neither field has a value we get the
    folowing show up in downtime "#VALUE" this of course doesnt look good from
    our customers point of view. is there a way to program excel that if onsite
    date is entered an no returned is uses the currentdate to work out how long
    vehicle has been there so far and if returned is entered but not onsite or if
    neither fields have values then the downtime will show an empty cell? also we
    need a way to filter out weekends from the calculations so only the amount of
    working days are displayed.

  2. #2
    Bob Phillips
    Guest

    Re: how do i build the macro i need?

    Se response in excel.misc

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Stuart" <Stuart@discussions.microsoft.com> wrote in message
    news:E22CE1FB-018A-43D4-8074-A92B3FDAF254@microsoft.com...
    > i work for an accident management company part of what we do for our fleet
    > customers is provide them with reports. in these reports we have a column

    in
    > an excel spreadsheet called downtime this uses the formulae =sum(H2-F2)

    where
    > column H is date vehicle was returned and column F is date vehicle came
    > onsite the answer is displayed as an integer value in the downtime column.
    >
    > however if onsite date is entered but no return date, or date returned
    > entered without an onsite date or neither field has a value we get the
    > folowing show up in downtime "#VALUE" this of course doesnt look good from
    > our customers point of view. is there a way to program excel that if

    onsite
    > date is entered an no returned is uses the currentdate to work out how

    long
    > vehicle has been there so far and if returned is entered but not onsite or

    if
    > neither fields have values then the downtime will show an empty cell? also

    we
    > need a way to filter out weekends from the calculations so only the amount

    of
    > working days are displayed.




+ 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