Forum Discussion
IF statement - Empty cell to be blank
Hi, I'm fairly basic with my excel knowledge. I have the below formula and table. The break column is a drop down box with selected times, I want the lunch column to return either a time of 12:15...
Or like this:
=IF(B2="", "", TIME(LEFT(B2, 2)+2, 15, 0))
Format C2 as hh:mm, then fill down.