Time Calculation

Occasional Visitor

Hi,

 

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 


Regards,

Alex

1 Reply

@Aleks1991 

In B2:

=MOD(A2-A$1,1)

Format B2 as time, then fill down.