Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 25 Apr 2024 23:33:34 +0000

How to Post a Message for Support

Post From: Spreadsheet question, Time values

[2014-01-13 18:27:36]
[Go To First Post]
Sawtooth - Posts: 3976
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.