Results 1 to 2 of 2

Thread: Calculate elapsed time a ship is spending at specific location

  1. #1

    Calculate elapsed time a ship is spending at specific location



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi there,

    Click image for larger version. 

Name:	09IWFPR.png 
Views:	14 
Size:	13.3 KB 
ID:	3256I am trying to find out how long (in days) a ship is spending at a specific location by analysing satellite data.


    This would be easy if the ship gave out consistent data, but due to technical issues it gives out inconsistent signals giving incorrect results. The satellite data also gives time data, but Iím not interested in that, only dates - hence the duplicate 02/12/14.


    Is there any way to take a subtotal count of location A (e.g. 5 satellite signals) as well as working out the elapsed days between 02/12 > 18/12 (e.g.: 16 days) spent at location A?

    Thanks!

  2. #2
    Yes possibly it coould be done if you provide example workbook of your case, to attach click "Go Advanced" button and then find paperclip image button to attach your file

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •