| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
problems with formating and concatonating time [hours]
|
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PROBLEMS WITH FORMATING COLUMNS | Excel Discussion (Misc queries) | |||
| date formating problems | Excel Discussion (Misc queries) | |||
| How do add time/hours to get answer in hours if Ans24 | Excel Worksheet Functions | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
| Formating Hours | Excel Worksheet Functions | |||
Linear Mode
