Date/Time function 1

[N1755L]

Good morning all,

With this formula:

=TEXT(NOW(),"dddd, mmmm dd, yyyy, hh:mm")

I have an output resembling this:

Monday, October 03, 2005, 10:40

I would like it to look as such:

Monday, October 03, 2005, 10:40 hrs

I've tried countless combinations of quotation marks and concatentations, but haven't yet hit on the right combination that will allow me to add the "hrs" text at the end of this string (no, I cannot add it in the column immediately to the right, and cannot add an extra column, has to be in the same cell).

There has to be a way...

Thanks.

 

[cowski]

How about this?

=TEXT(NOW(),"dddd, mmmm dd, yyyy, hh:mm") & " hrs"

works for me.

 

[electricpete]

That outta do it.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[ColourfulFigsnDiags]

Or

=CONCATENATE(TEXT(NOW(),"dddd, mmmm dd, yyyy, hh:mm")," hrs")

Read the Eng-Tips Site Policies at FAQ731-376

 

[N1755L]

That does it alright,

I remember putting the concatenation at the end like that, and using quotation marks... musta used 'em within the brackets... but thought I'd tried it like that as well. I'll be darned! Thanks guys.

 

[cummings54]

Of course you can also create a custom format for the cell containing just the =now() formula as follows:

dddd, mmmm, dd, yyyy hh:mm "hrs"

 

[electricpete]

Cool.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[N1755L]

Cool indeed. that opens up a lot of other possibilities/ideas...

Thanks.