Login Page - Create Account

Support Board


Date/Time: Sat, 20 Apr 2024 09:50:57 +0000



Post From: Spreadsheet question, Time values

[2014-01-13 23:11:26]
Sawtooth - Posts: 3976
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")