IF cell is coloured (any colour) count as 15 minutes and Sum as time durration

Hello,    I'm using Excel as a roster planner /timeline of events. Is it possible to get excel to look at a range of preceding cells in one row and count each coloured cell (colours need to be diff...