I need to calculate trip time so we see where we will be at certain times of the day. In cell L1 I have a cell with a value/format of 6:00 AM (which is departure time). In cells K2-K32 I have the cumulative travel time in hours like 2.94 hours that is based on mileage/mph. I also have this in cumulative minutes if that will work better. What I need is to somehow add the 2.94 hours to the 6:00 AM so we can see where we are at a certain time - this example would be 8:56:04 AM. If anybody feels there is a better way to do all of this I'm open to suggestions.
Thanks in Advance
Bookmarks