Time Formula

S

Stephen Lloyd

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

Rick Rothstein \(MVP - VB\)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell shows the last typed text, no matter where it is typed 0
Formula that displays the documents modified date 4
Nesting IF to correct #VALUE! Error Message 2
formula displays as a formula, not as its result 1
IF(ISBLANK) returning #VALUE 6
Summing up different time formats 6
displaying correct cell value 4
apply conditional format to time 1

Top