I'm trying to put together a sheet that calculates hours I work. One thing I want to do is calculate hours that are billable. So I have something like this:
Things that aren't billable or are already billed go to 0.
However, I'm having a problem with either the zeros that are generated or the field that adds them all together:
"Durations can't be compared to other data types." Here's my formula for the cell:
So, either the second value in the
COUNTIF is giving me problems or the zeros above are (which is possible, since doing a simple
SUM with a 0 value won't work either).
How do I deal with this? If I try to set the 0 cells or the sum cell at the bottom to the Data Format "Duration," it overrides my selection.
Is there a way to force a data format onto a cell with a formula?
If this is more suited to Super User, feel free to transfer.