Re: $$Excel-Macros$$ Combine Name then Time and date stamp for reference number

When I tried:=B1(B3,"hh:mm:ss")  I got:TestThis07:28:21 If you don't want the ":", then use:=B1(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,

Re: $$Excel-Macros$$ Combine Name then Time and date stamp for reference number

i tried this =B1(B3,"hhmmss") and is working fine. Could you please check it at your end On Fri, Nov 13, 2015 at 9:47 AM, Alex K wrote: > Hello, > >Please see attached file I am trying to combine first name + last name > + timestamp to create a case number. My

$$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&”