Nov 15 2022 03:21 PM
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
Nov 15 2022 03:28 PM