Login Page - Create Account

Support Board


Date/Time: Sun, 06 Jul 2025 02:24:03 +0000



Post From: Spreadsheet question

[2014-09-25 16:19:21]
Sawtooth - Posts: 4235
Try this:
=IF(MROUND(A3-INT(A3),1/86400)=TIMEVALUE("12:55:00"),E3,0)

The INT function removes the Date from the SerialDateTime, leaving only the Time.
The MROUND function rounds the Time to the second, removing floating point errors.
The TIMEVALUE function converts the text to a spreadsheet SerialDateTime value.
Date Time Of Last Edit: 2014-09-25 16:20:07