Another if then statement

**martindwilson** · 12-10-2010, 06:34 PM

depends ,do you want to use the 11:00 in other calculations? you cant have 2 formats in the same cell
similar to above
=IF(OR(C5="V1",C5="V2",C5="V3"),(B6-B5+(B6<B5))*24,TEXT(B6,"hh:mm")) format general

**jonvanwyk** · 12-12-2010, 02:51 PM

Originally Posted by martindwilson

depends ,do you want to use the 11:00 in other calculations? you cant have 2 formats in the same cell
similar to above
=IF(OR(C5="V1",C5="V2",C5="V3"),(B6-B5+(B6<B5))*24,TEXT(B6,"hh:mm")) format general

This worked :-) Thank you.