General discussion

Locked

Excel Date & Time

By Ken G. ·
Hey all,

I'm trying to come up with a formula that calculates the departure time, return time then time remaining until return (ETA). Example:

Cell A1 (Scheduled Departure Time)
Cell A3 (Scheduled Return Time)
Cell A5 (ETA - Time Remaining until arrival)

How do I do setup this for real time tracking? There are 49 vehicles that operate 24/7 in my fleet. Being able to do this would be a TREMENDOUS help in scheduling. Please help?!

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by BFilmFan In reply to Excel Date & Time

I would think you would need an entire freight management and dispatch software system, which is way beyond the capabilities of an Excel spreadsheet.

I'd advise looking into CSI's software. And they work with independent computer consultants.

http://www.csiroad.com/

Collapse -

by Ken G. In reply to

Thats great but not what I was looking for.

Collapse -

by Ken G. In reply to Excel Date & Time

These times would be posted in the appropriate cells by the day. We have software to do this called Xata OpCenter but it's worthless for the task here.

Just a simple table format ranging down the columns with departure and return adjacent to each other with the formula in the next cell (A5) in this case.

I've mentioned software avenues but it's falling on deaf ears if you know what I mean. So this would be very useful.

Collapse -

by DKlippert In reply to Excel Date & Time

Assuming you know the Departure time and the Return time, the length of the trip is just
=A1-A3.
Format the cell as [h]:mm:ss
The ETA is
=A3-NOW()
also formatted as [h]:mm:ss
For a complete discussion on Date math, see:

http://www.cpearson.com/excel/datetime.htm#TOC

Collapse -

by Ken G. In reply to

Cool, I had the formula backwards was all. Something so simple! Man I'm a dolt. Thank you sir :)

Collapse -

by Ken G. In reply to Excel Date & Time

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums