Another if then statement

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.