How to calculate cell status time?

A

aMoony2019-02-20 22:18:06

Google Sheets

aMoony, 2019-02-20 22:18:06

Interested in whether it is possible in live mode to calculate the time spent by a cell in a certain status. Specifically, there is a cell with a drop-down list "ready, not ready, working." Is it possible to calculate how long the cell was in the status "ready, not ready" and so on? So to say pseudo CRM, or something.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander Ivanov, 2019-02-20
@oshliaer

You can record cell change time via scripts and calculate periods from this.