#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Running Clock

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Running Clock

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
--
Gary''s Student - gsnu200773


"Ralph" wrote:

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I calculate time in excel (clock in and clock out chad Excel Discussion (Misc queries) 3 January 7th 08 10:09 PM
A running clock Cara Excel Worksheet Functions 1 August 13th 07 05:25 PM
Change EXCEL Clock to Standard Clock or Military Time YoMarie Excel Worksheet Functions 4 April 29th 07 08:39 PM
Start Clock/Stop Clock abfabrob Excel Discussion (Misc queries) 9 June 28th 05 04:26 PM
clock Wildman Excel Worksheet Functions 2 April 26th 05 10:31 AM


All times are GMT +1. The time now is 12:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"