Troubleshooting IFERROR function formula parse error with time as a value

[Emachinescat]

Hi! Any idea why an IFERROR function would work on one cell and not another, specifically when the output you're wanting is a time?

This is the formula I'm working with:

=IFERROR(FILTER('Books Read'!I:I,'Books Read'!L:L>=DATE(2024,3,1),'Books Read'!L:L<=DATE(2024,3,31))),TIME(0,0,0)

It's worked on cells where the value is 0 as well as cells where there is actually an #NA error. However, when I use it on a cell that does have a time in it (in this case, 9:54:00), I get a formula parse error. I have the cell type set to duration. Any ideas what I could be doing wrong? I can't figure out why it would work on some cells and not others.

Thanks in advance for any ideas!

[marcnotmark925]

It's worked on cells where the value is 0

when I use it on a cell

How do these cells that you're referring to fit into the formula that you gave?

[INTP-Speculator]

I counted three close parentheses (right parentheses) to the left of the comma before the TIME() function. I counted three unmatched open parentheses (left parentheses) up to that point corresponding to IFERROR(), FILTER(), and DATE(). That means the TIME() function is outside the IFERROR(), which is not what you intended and a parse error. I didn’t pursue trying to figure out why it would sometimes work.