| 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 |
| 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 | |||
Threaded Mode
