# Software

## General discussion

Locked

### Excel Date & Time

By ·
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.

Thread display: Collapse - | Expand +

Collapse -
by 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.

Collapse -

Thats great but not what I was looking for.

Collapse -
by 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 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 -

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

Collapse -
by In reply to Excel Date & Time

This question was closed by the author

## Related Discussions

• 2

• 5

#### LMS Software

singhsima002 ·

• 6

#### Bookkeeping or Accounting Software

singhsima002 ·

• 2

#### what are the software required for creative content?

aravindmuniraj ·

• 1

#### Program To Import Graphics and Arrange Automatically

brookpark351 ·