Register now or log in to join your professional community.
i thinkC is the answer.....
=now() ."......".........."........
=now() enters the current date and time
=time(h,m,s) will enter e.g.10:10 AM
=timevalue()12:00 PM would be0.5 as it is half a day
So C) is the correct answer
I like the Control + Shift + : works well, and is a stable consistent time.
In order to enter current time in a worksheet cell, use CTRL+SHIFT+; (semicolon).
use CTRL+SHIFT+; (semi-colon) to enter the current time in a cell
Now() function. Current date and current time is displayed into the selected cell.
B) >>>>>>>>>>>>>>>>>>>>=now()
C-time is the right answer
The function that you will use to enter current time in a worksheet is time value