Thread: problems with formating and concatonating time [hours]
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default problems with formating and concatonating time [hours]
On Sun, 6 Jul 2008 21:38:03 +0200, Bret Bernever
wrote:

In article ,
says...

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


Thanks Ron, did the trick!

Glad to help. Thanks for the feedback.
--ron
Reply With QuoteReply With Quote