ExcelBanter - problems with formating and concatonating time [hours]

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - problems with formating and concatonating time [hours] (https://www.excelbanter.com/excel-worksheet-functions/193832-problems-formating-concatonating-time-%5Bhours%5D.html)

Bret Bernever

problems with formating and concatonating time [hours]

Hello Excellers,

This is my problem:

B2 = 10:00
D1 = 11:00

Formula in D2
=B2 & " - " & D1

Result in D2 shows
0,25 - 0,260416666666667

But it should look like this
10:00 - 11:00

How to tackle this?
Thanks in advance, bret bernever

Ron Rosenfeld

problems with formating and concatonating time [hours]

On Sun, 6 Jul 2008 20:50:31 +0200, Bret Bernever
wrote:

Hello Excellers,

This is my problem:

B2 = 10:00
D1 = 11:00

Formula in D2
=B2 & " - " & D1

Result in D2 shows
0,25 - 0,260416666666667

But it should look like this
10:00 - 11:00

How to tackle this?
Thanks in advance, bret bernever

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

Bret Bernever

problems with formating and concatonating time [hours]

In article ,
says...

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

Thanks Ron, did the trick!

Ron Rosenfeld

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

All times are GMT +1. The time now is 12:53 PM.