When I tried: =B1&B2&TEXT(B3,"hh:mm:ss")
I got: TestThis07:28:21
If you don't want the ":", then use: =B1&B2&TEXT(B3,"hhmmss")
If you're not getting this, are you getting some kind of error?
-------to explain your "strange timestamp":
Excel stores dates as a number.The number of days since 1/1/1900
So, November 12, 2015 is 42,320 says since 1/1/1900
By storing it as a number, the value can be DISPLAYED in whatever format is
wished.and date calculations can be easily performed.
TIME is also a number. It's the fractional part of a day.
at 6:00am, 6/24ths of a day is complete, or .25 of a day.at noon, 1/2 of the
day is gone.
7:33am is .3127024306 of a day.
so, November 12, 2015 at 7:33am is 42320.3127024306
Paul-----------------------------------------
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-----------------------------------------
From: Alex K <vipinsuranc...@gmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Thursday, November 12, 2015 11:17 PM
Subject: $$Excel-Macros$$ Combine Name then Time and date stamp for reference
number
Hello,
Please see attached file I am trying to combine first name + last name +
timestamp to create a case number. My issue is that when I merge all three
together I get a strange time stamp I want HH:MM:SS can anyone help me ?
I tried something like this still didn't work
=B2&” “&TEXT(B3,”hh:mm:ss”)
Actual Results: TestThis42320.9670534722
|
|
Expected Result: TestThis231222
thanks,
Alex--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
