Skip to content

Instantly share code, notes, and snippets.

@xgeek-net

xgeek-net/DateTime.js

Created May 14, 2015 08:01
Show Gist options
  • Save xgeek-net/e3959288025cfdceab95 to your computer and use it in GitHub Desktop.
Save xgeek-net/e3959288025cfdceab95 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
DateTime.js
TEXT(MONTH(DATEVALUE(NOW())))+"/" +TEXT(DAY(DATEVALUE(NOW())))+"/" +TEXT(YEAR(DATEVALUE(NOW()))) & " " &
MID(TEXT(NOW()-TZoffset), 12, 2) & ":" &
MID(TEXT(NOW()-TZoffset), 15, 2) & ":" &
MID(TEXT(NOW()-TZoffset ), 18, 2)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment