| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Concatenate/Text Functions
I wrote the following formula to attempt to convert decimal values in two
separate cells to a h:mm format in one cell: =CONCATENATE(TEXT(B7/24,"h:mm")," - ",TEXT(C7/24,"h:mm")) Cell B7 has a value of .29... and cell c7 has a value of .66. The formula produced the following result: "0:17 - 0:40". This is exactly the format I was looking for but the value I was looking for was " 7:00 PM - 4:00 PM". What am I doing wrong? Any feedback would be very much appreciated. Thanks. -- Brian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Concatenate/Text Functions
See response in worksheet.functions
-- HTH RP (remove nothere from the email address if mailing direct) "brianwakin" wrote in message ... I wrote the following formula to attempt to convert decimal values in two separate cells to a h:mm format in one cell: =CONCATENATE(TEXT(B7/24,"h:mm")," - ",TEXT(C7/24,"h:mm")) Cell B7 has a value of .29... and cell c7 has a value of .66. The formula produced the following result: "0:17 - 0:40". This is exactly the format I was looking for but the value I was looking for was " 7:00 PM - 4:00 PM". What am I doing wrong? Any feedback would be very much appreciated. Thanks. -- Brian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TEXT & DATES & CONCATENATE | Excel Discussion (Misc queries) | |||
| How to concatenate cell & text in a text box? | Excel Worksheet Functions | |||
| concatenate and hyperlink functions | Excel Worksheet Functions | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| Concatenate/Time Functions | Excel Worksheet Functions | |||
Linear Mode
