Support Board
Date/Time: Sat, 10 May 2025 00:43:43 +0000
Post From: Spreadsheet question, Time values
| [2014-01-13 18:27:36] |
| Sawtooth - Posts: 4214 |
|
Try this: =(J41-INT(J41))-(J42-INT(J42))<TIMEVALUE("00:05:00") This removes the dates from the date-times, finds the difference, and compares it to the Excel timevalue of 5 minutes. |