ETA formula

K

Ken

Hey all,

I'm trying to come up with a formula that will take the current time and
subtract down to 0:00 giving an argument of an expected time an event will
happen using the 24 hour clock. Example:

A B
1 Arrival Time Remaining
2 17:00 (Current time - cell A2)

Using the =NOW() function - A2 is not working. What am I doing wrong? I've
tried formatting the time using Custom to no avail.

Cell A2 would be the time entered in manually and cell B2 the destination
cell with the formula. Please help! TIA
 
K

Ken

It works great Jordon! Fantabulous!! Only problem is; arrivals for the next
day. I get the infamous ####### when those times are entered. I hate to
impose but, how do we accomplish that? For example: 04:45 the next day.
Thanks again bud. You're a life saver!
 
Top