Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Date/Time function

Date/Time function

Date/Time function

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...


RE: Date/Time function

How about this?

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

works for me.

RE: Date/Time function

That outta do it.

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

RE: Date/Time function


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

Read the Eng-Tips Site Policies at FAQ731-376  

RE: Date/Time function

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.

RE: Date/Time function

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"

RE: Date/Time function


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

RE: Date/Time function

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


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close