Easy Way to enter the current time with the date

[seansr]

I have various forms that I am going to give to clients to fill in.
One section they will fill in is the Date they complete, and send to us.
Based on this date, it will determin how many days we have to complete the work.
I have a formatted the cell with this format, "dddd dd mmm yy hh:mm AM/PM" but I can't be expecting the customer to add the time.
The reason I have got the am/pm is a form submitted in am when using This Formular in the cell below =WORKDAY.INTL(D14,1+(MOD(D14,1)>=0.5),1,0) it add the one day. If sumbitted in PM will add extra day. I can't be expecting customer to put in the time.
I have tried Circular references to add a static time but that just not right.
Ideally don't want Macro buttons.
Don't mind having Hidden Cells, as long as easy and seemless for customer

Name
Date Monday 26 Nov 18 02:52 PM
SLA Completion Date Wednesday 28 Nov 18
Contact Email Address
Contact Telephone No



Any Hope Gratefully Recieved
Sean

 

[Chihiro]

CTRL+; to enter date. Then hit space bar. CTRL+SHIFT+;.

This will enter date & time into cell.

Otherwise, you'd need to use circular referencing via formula, or some control using VBA.

See link for method using circular referencing.
https://chandoo.org/wp/timestamps-excel-formula-help/

 

[Peter Bartholomew]

Ideally don't want Macro buttons

Is it interaction with the button you don't want or the idea of having a macro-enabled workbook? If you want a timestamp to reflect the time the form was submitted then you could use worksheet change events to fill in the date and time for the customer.

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
    If Not Intersect(Target, [Initials]) Is Nothing Then
        Target.Offset(, -1).Value = Now
     End If
Application.EnableEvents = True
End Sub