Forum Discussion
IF cell is coloured (any colour) count as 15 minutes and Sum as time durration
Have to agree with mathetes . Why try to calculate with colours. It is so much easier with numbers. I guess that someone is actually selecting the cells of the shift and giving it a color. He/she might as well enter the number 1 and press Ctrl-Enter (on a Mac) and enter it in all selected cells simultaneously. If you then conditionally format the entire roster, all cells with "1" can be given a highlight. And the summary you asked for (Start, Finish and Duration) is then fairly easily calculated in a formula. The attached workbook contains a small scale example. Perhaps you will reconsider your initial design/approach.
By the way, I entered some helper rows at the top (hidden), just to help me create the example. If you already have a row with all quarters in a time format, you may ignore these.