Static Time in Excel

ethan2002

New Member
Joined
Jan 18, 2005
Messages
3
I know how to capture the time but the time keeps changing within the cell as the PC changes time. I want an automatic time capture that does not change with the PC....I know that this works =now()-today() but the time within the cell will change with the PC time........Is there anyway to keep this from happening?
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,029
If you search for 'enter time' in XL help, the first suggested topic (at least in XL2003) is 'Enter data in worksheet cells' The first section in that topic is 'Enter numbers, text, a date, or a time' It tells you how to enter the current time.

You may also want to check an enhancement:
Enter time with seconds
http://www.tushar-mehta.com/excel/tips/time_in_secs.html
 

Forum statistics

Threads
1,148,222
Messages
5,745,467
Members
423,952
Latest member
EduardoM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top