Another if then statement

Originally Posted by ChemistB

Yes, that is how that formula should work (IF cell C5 is either V1, V2 or V3, then subtract B5 from B6, otherwise enter B6). So what is happening?

Well, I just realized it is doing the math correctly, but it is converting my "4" into 4:00. I have a different spread sheet where I have a similar equation, and when the result is time, it shows time, and when the result is a integer, it shows the integer.