Thread: need help with a If=then situation.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim[_3_] Carim[_3_] is offline
external usenet poster
  
Posts: 137
Default need help with a If=then situation.
Bill,

The easiest is a formula :
=VALUE(LEFT(H6,2)&":"&RIGHT(H6,2))
and then format the cell with time ...

HTH
Carim

Reply With QuoteReply With Quote