Formula for counting minute intervals
if your list of times is in column A,
put this formula in column B:
=IF(ISERROR(MINUTE(A9-A8)),"",MINUTE(A9-A8))
then select column b, Choose "Conditional Formatting", from the Format
menu, and enter the criteria and formatting you desire.
|