Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

A) =today()

B) =now()

C) =time()

D) =currentTime()

user-image
Question added by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
Date Posted: 2015/05/14
Muhammad Kabeer Ud Din
by Muhammad Kabeer Ud Din , Trainee Engineer , pakistan machine tool factory

i thinkC is the answer.....

Ahmed Maher allam
by Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

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

Deleted user
by Deleted user

=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
by Azharuddin Mohammed Khaja , FINANCE & ADMINISTRATION EXECUTIVE , AIN CORPORATION SECURITY SOLUTIONS INDIA PVT LTD

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

qasim ali
by qasim ali , IT specialist , Pakistan Punjab Police

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

 

Mohammed Kaleem Uddin
by Mohammed Kaleem Uddin , Product owner , Wells Fargo

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

FITAH MOHAMED
by FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

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

Pankaj Singh- CMRP
by Pankaj Singh- CMRP , Senior Reliability Engineer , Marafeq Qatar

C-time  is the right answer

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

Yash Singh
by Yash Singh , Nothing , Nothing

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

More Questions Like This