Solved

Time Question

Posted on 2011-03-13
2
185 Views
Last Modified: 2012-05-11
Hello i have two cells C6 and F6 that have the value 04Z and 09Z, the format for these cells are hhZ, which is hour followed by the Zulu.  How to I combine both values in a cell to read 04Z - 09Z.
0
Comment
Question by:sandramac
2 Comments
 
LVL 19

Expert Comment

by:MINDSUPERB
ID: 35122831
Try this formula:

=concatenate(c6,"-",f6)

or

=c6&"-"&f6

Sincerely,
Ed
0
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 500 total points
ID: 35122860
I think you want this...

=TEXT(C6,"hhZ")&" - "&TEXT(F6,"hhZ")

Sid
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question