ExcelBanter - Time Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Time Formula (https://www.excelbanter.com/excel-worksheet-functions/193198-time-formula.html)

Té

Time Formula

Is there a formula that displays the current time? Now displays the date and
time.

Jarek Kujawa[_2_]

Time Formula

re-format yr cell to "hh:mm" and leave =NOW() in place

Stephen Lloyd[_2_]

Time Formula

Change the cell format from General, or whatever it is currently set to, to
Time.

"Té" wrote:

Is there a formula that displays the current time? Now displays the date and
time.

Rick Rothstein \(MVP - VB\)[_799_]

Time Formula

You could do this...

=NOW()-TODAY()

More than likely, this will display as a decimal value, so you will probably
have to format the cell as Time.

Rick

"Té" wrote in message
...
Is there a formula that displays the current time? Now displays the date
and
time.

All times are GMT +1. The time now is 06:07 AM.