Running Clock

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ralph - 13 Mar 2008 23:47 GMT

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

Reply to this Message

Gary''s Student - 14 Mar 2008 00:41 GMT

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

Signature

Gary''s Student - gsnu200773

> 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

Reply to this Message