Thread: Converting military times to numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Converting military times to numbers
Hi,

Would the following be of any help :
=VALUE(TEXT(A1,"hhmm"))

HTH
Carim

Reply With QuoteReply With Quote