IF function with Time duration

Killian - Jan 27, 2016 at 12:21 PM
 Blocked Profile - Jan 28, 2016 at 04:33 PM
I dont understanding why this can't work :


G2 has a time duration time unit in it which equals 0:30. I am trying to show that if something lasted 30 minutes I need another cell to say that it will cost 25

Thank you


2 replies

Blocked Profile
Jan 27, 2016 at 05:01 PM
Your syntax is wrong in multiple areas. There is a comma delimiter, not a colon, and you have no end quotes.

Try this:

that syntax is correct.
wow, thank you!!!! it worked

Except for some of the cells that are equal 0:30 it still shows as blank, but for most it doesnt.

How would I also add other parameters. Say: if f2=saturday, g2=0:30 then 35 . if f2=monday, g2=0:30 then 25
Blocked Profile
Jan 28, 2016 at 04:33 PM
It is possible to nest if statements. It can get messy. I am certain there is a cleaner way, I just never had to expand beyond two or three choices.

The nested if looks like this:

I hope this helps. If you are satisfied, mark it as solved! Thanks and HAVE FUN!