Convert Time to a Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need help with a formula. I'm trying to convert a time to text as in the
example below.

Example:
A1= 5:16 PM
B1= 1716

Thanks for any help!
 
One approach:

=TEXT(HOUR(A1,"00") & TEXT(MINUTE(A1),"00")

HTH,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert times to text string 3
Which is the best MBOX Converter Tool different formats conversion? 4
Scrabble Value calculation for Welsh words 0
Windows 7 I need to convert date to text 3
Countifs with different restrictions 1
Special string convertion to date and time 4
SUMIF with criteria "<>" & "=" 4
Converting text format of time/date into Excel time/date for subtr 5

Back
Top