Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I calculate time in excel (clock in and clock out | Excel Discussion (Misc queries) | |||
A running clock | Excel Worksheet Functions | |||
Change EXCEL Clock to Standard Clock or Military Time | Excel Worksheet Functions | |||
Start Clock/Stop Clock | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |