Time Calculation

Occasional Visitor



I have a collection schedule that has set times for collections (multiple for some). I need excel to look at the current time (=NOW) then work out the duration to the next collection?


Cell A1 is 23:00:00 (Current Time)

Cell A2 is 16:00:00

Cell A3 is 23:30:00


I need B:B to work out the + / - duration time 



1 Reply


In B2:


Format B2 as time, then fill down.