Running Clock

  • Thread starter Thread starter Ralph
  • Start date Start date
R

Ralph

This is what i need to do. i need a running clock that shows days, hours and
min from 12-27-2007. im very new to this, so if you can help, please spell
it out very well
 
In cell A1 enter:
=NOW()-DATE(2007,12,27)
In cell A2 enter:
=INT(A1) & " " & TEXT(MOD(A1,1),"hh:mm")

This will refresh every time the worksheet is calculated
 

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

Daily Time Sheets with Rounding 1
Countdown Clock 4
Display time format 1
[HELP]CLOCK TIMER USING ECXEL 0
Highlight Alternating Days 2
Need help with formula 3
Time Clock Intervals 2
24 Hour Clock Calculations 1

Back
Top