Results 1 to 2 of 2

Solution needed to compare overtime vs vehicle tracker data

Threaded View

  1. #1
    Registered User
    Join Date
    05-30-2019
    Location
    London
    MS-Off Ver
    2013
    Posts
    1

    Solution needed to compare overtime vs vehicle tracker data

    Hello all,

    I have an interesting problem to solve and need some help.

    The objective is to compare driver status (i.e engine off) data to whether the driver is claiming in overtime and sum the number of minutes if the driver is over claiming (for example they are claiming overtime but they havnt even started the vehicle up, or vice versa by claiming when their vehicle is switched off).

    The overtime data is in a different format to the driver data and on a large scale would be time consuming to manually copy and paste into the same format.

    Many thanks in advance for solutions!
    Attached Files Attached Files
    Last edited by sharpshooter80; 05-30-2019 at 11:25 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Stuggling with Error 9
    By kheman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-05-2018, 12:14 PM
  2. [SOLVED] compare cell formats
    By Gary''s Student in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-04-2017, 08:50 AM
  3. Compare/recognize two different formats of month, other issues.
    By NIKNIKNIK in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-07-2015, 01:33 PM
  4. [SOLVED] Macro to convert date formats in two columns and compare
    By shanky2704 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2014, 05:02 PM
  5. VBA to compare cell formats
    By swaaroopparuchuri in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2014, 06:20 PM
  6. VBA to compare cell formats
    By swaaroopparuchuri in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2014, 06:30 AM
  7. Compare Formats
    By wilro85 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2010, 12:13 PM

Tags for this Thread

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