Support Board
Date/Time: Fri, 24 Oct 2025 02:56:23 +0000
Post From: Spreadsheet question, Time values
| [2014-01-13 23:11:26] |
| Sawtooth - Posts: 4278 |
|
You're correct: The formula in post #2 assumes you do not cross midnight. To include the dates, try this: =J41-J42<TIMEVALUE("00:05:00") |