IF function with Time duration

Closed

Killian - Jan 27, 2016 at 12:21 PM
Blocked Profile - Jan 28, 2016 at 04:33 PM

Hello,
I dont understanding why this can't work :

=IF((g2=timevalue("0:30"));"25)

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

Which function will you use to enter current date in a worksheet cell
Activeworkbook.worksheets current worksheet ✓ - Excel Forum
How to enter @ in laptop - Guide
Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
Insert the current date and time in cell a1 ✓ - Excel Forum
Enter key will send your message - Guide

2 responses

Answer 1 / 2

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:
=IF((g2=timevalue("0:30")),"25","BLANK")

that syntax is correct.

Killian
Jan 28, 2016 at 05:57 AM

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

Similar discussions

Use of '@' in formulae

If cell A1 has text then cell B2 has today's Date

"Sorry, this feature isn't available ... " how to fix this?

help me to add particular cells

Excel if range of cell contain a text put a cell value in

How to stop today function date changing every day in Excel

Similar discussions

Subscribe To Our Newsletter!