Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Fri, 20 Sep 2024 08:53:51 +0000

How to Post a Message for Support

Post From: Spreadsheet question

[2014-09-25 16:19:21]
[Go To First Post]
Sawtooth - Posts: 4091
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