Which function will you use to enter current time in a worksheet cell?

Question

A) =today()

B) =now()

C) =time()

D) =currentTime()

Muhammad Kabeer Ud Din · Answer

i thinkC is the answer.....

Ahmed Maher allam · Answer

=now() ."......".........."........

Deleted user · Answer

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

Azharuddin Mohammed Khaja · Answer

In order to enter current time in a worksheet cell, use CTRL+SHIFT+; (semicolon).

qasim ali · Answer

use CTRL+SHIFT+; (semi-colon) to enter the current time in a cell

Mohammed Kaleem Uddin · Answer

Now() function. Current date and current time is displayed into the selected cell.

FITAH MOHAMED · Answer

B) >>>>>>>>>>>>>>>>>>>>=now()

Pankaj Singh- CMRP · Answer

C-time is the right answer

Lehlogonolo Mootane · Answer

The function that you will use to enter current time in a worksheet is time value

Yash Singh · Answer

Answer would be B: =now() because its so the current time and the date on the worksheet cell