+ Reply to Thread
Results 1 to 2 of 2

periods of time

  1. #1
    Ben
    Guest

    periods of time

    Hi

    Can somebody help me with this please,i need a formular that can calculate
    the difference between the two times and show the answer as a plus or minus
    or green/red.For example in the below, the answer would be +1:30 as the
    actual time is an 1hr 30min before the expected.

    Expected arrival time 8:00 Actual arrival time 6:30 answer

    Thanks
    Ben

  2. #2
    Registered User
    Join Date
    03-07-2004
    Posts
    6
    Hello again Ben,

    You need the following formula in column D:

    =(B1-A1)*24

    You will need to format the result cells to be General formats not dates. To do the highlight all the expected results cells for column D and hold Ctrl + Shift and press #. This will set the cells to General formatting.

    If you also want different colours you will also need Conditional Formatting:

    Highlight the results cells in column D and choose Format + Conditional Formatting.

    Change the Between text to Greater than 0 and click the Format button - choose grenn.
    Click the Add button. Change the Between text to Less than 0 and choose the second Format button - choose Green.

    Post again with any problems

    Judith

+ 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