Formula Help

How precise do these times need to be? Are the drivers paid by the minute? Do you trust them to enter a time, rather than have it entered based on logging in?

There certainly are macros that could be written (though not by me) to simply record the time when X happens. :That is to say, it's not a formula (as you've discovered), since formulas get evaluated every time something happens.

But short of a macro, depending on the level of precision and whether or not you trust your drivers, you could develop a drop down from which the drivers select a start (and finish?) time to the closest 5, 10, or 15 minutes. Once selected, that would stay.

Before we show you how to do it, though, we'd need the answers to my first set of questions.. Or you can ask for a macro, and I'll leave that to those who know how to write macros.