Insert current time

Author Topic: Insert current time  (Read 9112 times)

Offline rahikumarTopic starter

  • Trade Count: (0)
  • Newbie
  • *
  • Thank You 0
  • Posts: 2
  • Karma: 0
Insert current time
« on: 05-10-2011, 03:03:32 »
Hello,

I wrote a script to insert the current time on a field depending on another field

for example if my field "start" = "Now" then my field "pick_start_time" should get the current time

what my script is doing when "start" = "Now" I get redirected to a blank page with the time on it
not sure how to get the time on my "pick_start_time" field

here is what I have so far

Code:
Only registered users can see contents. Please click here to Register or Login.


Offline damponting44

  • Trade Count: (0)
  • Hero Member
  • *****
  • Thank You 26
  • Posts: 610
  • Karma: 0
  • Gender: Male
    • Hosting Forum
Re: Insert current time
« Reply #1 on: 02-18-2018, 22:37:41 »
A static value in a worksheet is one that doesn’t change when the worksheet is recalculated or opened. When you press a key combination such as Ctrl+; to insert the current date in a cell, Excel “takes a snapshot” of the current date and then inserts the date in the cell. Because that cell’s value doesn’t change, it’s considered static.


Offline Lishmalinyjames

  • Trade Count: (0)
  • Hero Member
  • *****
  • Thank You 3
  • Posts: 797
  • Karma: 0
    • Oneplus Service Center in Chennai
Re: Insert current time
« Reply #2 on: 06-26-2021, 13:41:39 »
To insert the current time, press Ctrl+Shift+; (semi-colon). To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).
=TODAY(): Current date (varies)
=NOW(): Current date and time (varies)

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
2615 Views
Last post 08-20-2013, 23:48:57
by topthisfact
12 Replies
15163 Views
Last post 09-28-2022, 05:06:51
by f1dark
6 Replies
4653 Views
Last post 02-18-2018, 22:40:37
by damponting44
1 Replies
1698 Views
Last post 10-04-2017, 02:08:51
by komal
3 Replies
5331 Views
Last post 12-28-2018, 02:10:28
by johnv5