I need help with a Google spreadsheet formula. This is what I'm trying to do:
Highlight the cells in “Conditional Formatting” where the time spent between 2 cells is more than 60min. In this case the B cell should be highlighted because the activity stopped for more than an hour.
Which formula to use? I try to change time format to number and compare between the cells but no success. Any idea please?