Greatest thread title ever?
Not really sure how to word this one so bear with me.
I want an object to arrive at its destination at a given time and date hh:mm:ss - dd:mm:yy - call this ETA
The time it takes to arrive varies depending on where it's sent from but will always be shown in hours, minutes and seconds - [hh]:mm:ss - call this travel time
Using the above information I want to find out the time and day I'd have to send the object to arrive at the given ETA
What formula would I use to subtract travel time from ETA and display the result as a date and time (hh:mm:ss dd:mm:yy).
I think that makes sense but I'm sure someone will tell me if it doesn't
Thanks in advance.


LinkBack URL
About LinkBacks

Reply With Quote


