Software

Ask something
Discussion Locked

Excel Date & Time

0 helpful
6 replies

by ken g.

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

6 replies

by bfilmfan

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/

by ken g.

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.

by ken g.

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

This discussion is closed to new replies.