Complex IF - help needed

Calc fields are coded slightly different than report columns. The main difference is in the field naming convention. In the API, under the Task object, you can see "Planned Hours" equals "workRequired". In creating calc fields, the usual would be to use the simple name on the left. While in a report, you would use the API code name on the right in curly brackets {workRequired}.

I haven't trried this in a calc field but I think a good starting point would be to try a single IF and make sure that works first. Then you can add a second and third. I would dump the brackets from your "then" replies too. Instead of:

IF(Planned Hours>1,"(1h-3h]","[0-1h]")

I would start with:

IF(Planned Hours>60,"1h-3h","0-1h")

In the calc field creator, there is a syntax coloured editor with a built in wizard that allows you to select items from a dropdown. It is quite good and I highly recommend it. If you need to tweak code after you've selected as much as you can from the wizard you can. The wizard will gewt you most of the way there though.

Remember, if you're going to do this in a calc field, all tasks have to have the form attached with the field on it and it has to be a tasks form. This will not work on a project form as tasks would be a collection, not an object.