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 responses

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