thanks for the help!!! I still have a little trouble, getting the formula to work on the dates. I had to modify my form. I have attached the spreadsheet. the 3 front columns need to be added to gather, then subtracted from the date. then color coded.

Attached Files

duration times.xlsx (12.0 KB, 10 views)