ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Static time - again (https://www.excelbanter.com/excel-worksheet-functions/101727-static-time-again.html)

Maverick

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.

Beege

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.




Peo Sjoblom

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.




Bob Phillips

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.





All times are GMT +1. The time now is 03:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com