| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Static time - again
Let me explain better what I am trying to do. When I enter data in cell C:1
I need the exact time (hh:mm:ss) entered in cell B:1 and when data is entered in cell C:2 I need the exact time entered in cell B:2 and so on. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Static time - again
Maverick,
Check out... http://www.mcgimpsey.com/excel/timestamp.html (after a Google of "excel timestamp") Beege "Maverick" wrote in message ... Let me explain better what I am trying to do. When I enter data in cell C:1 I need the exact time (hh:mm:ss) entered in cell B:1 and when data is entered in cell C:2 I need the exact time entered in cell B:2 and so on. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Static time - again
See answer in your previous post
-- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Maverick" wrote in message ... Let me explain better what I am trying to do. When I enter data in cell C:1 I need the exact time (hh:mm:ss) entered in cell B:1 and when data is entered in cell C:2 I need the exact time entered in cell B:2 and so on. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Static time - again
See other thread.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Maverick" wrote in message ... Let me explain better what I am trying to do. When I enter data in cell C:1 I need the exact time (hh:mm:ss) entered in cell B:1 and when data is entered in cell C:2 I need the exact time entered in cell B:2 and so on. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hot key for time? | New Users to Excel | |||
| Hot key for time? | Excel Discussion (Misc queries) | |||
| static time in formula | Excel Worksheet Functions | |||
| how do I insert the current time (static) and date in a cell? | Excel Discussion (Misc queries) | |||
| time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
Hybrid Mode
