Work out elapsed time spent at a location

[chakyt]

I 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!

 

[Stridhan]

or reference the cell A2 instead of giving it static values

 

[chakyt]

Hi, I tried that. Still 0. Can I send the spreadsheet to you?

Thanks,

 

[Stridhan]

You've got a PM

 

[RonB1111]

Did you see post #9 (copied below). What happens in my 2nd question?

Please verify a couple things:
1. Make sure the 100.13 in A2 is not, for instance 100.12895. (in format cells, increase the number of decimals to verify its 100.13000000)
2. Make sure the dates in Col D are in Excel Date Format, and not text in the form of 2014-12-14 (if you format the cell as a Number, it should display 41,997)