Thread: problems with formating and concatonating time [hours]
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bret Bernever Bret Bernever is offline
external usenet poster
  
Posts: 27
Default problems with formating and concatonating time [hours]
In article ,
says...

=TEXT(B2,"hh:mm") & " - " & TEXT(D1,"hh:mm")
--ron


Thanks Ron, did the trick!
Reply With QuoteReply With Quote