A function for the current time?

[DashboardNovice]

TODAY ( ) returns the current date and NOW ( ) returns the current date and time.

But what if I want a function that returns the current time only? Is there a function for this?

 

[Syedali]

Hi,
Try this.
=NOW()-TODAY()

 

[NARAYANK991]

Hi ,

Another option would be :

=MOD(NOW(),1)

Narayan

 

[Khalid NGO]

Hi,
Just an alternate...

You can use =NOW() function to display only time, just change the cell format:
hh:mm
or
h:mm AM/PM

 

[Deepak]

You have to manipulate now() to get the current time.

Another one...
=TEXT(NOW(),"HH:MM:SS am/pm")

 

[NARAYANK991]

Hi Khalid ,

The problem with using cell formatting to display only the time component is that the underlying value in the cell remains a large decimal value inclusive of the date component.

If the value is only the time component , then it will be a decimal value between 0 and 1.

Narayan

 

[Khalid NGO]

Yap... Narayan Sir you are right, I didn't thought about that