T Té Jun 30, 2008 #1 Is there a formula that displays the current time? Now displays the date and time.
S Stephen Lloyd Jun 30, 2008 #3 Change the cell format from General, or whatever it is currently set to, to Time.
R Rick Rothstein \(MVP - VB\) Jun 30, 2008 #4 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
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
