Support Board
Date/Time: Wed, 27 Nov 2024 18:43:28 +0000
Post From: Spreadsheet question
| [2014-09-25 16:19:21] |
| Sawtooth - Posts: 4120 |
|
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
|