Time Stamp in Excel Mobile, Windows Mobile 5.0

B

Brian72984

I would like to create a time stamp on a spreadsheet such that when a
certain action occurs, I can simply tap on a cell (or a couple of
taps) to input the current time to the nearest second in a cell. While
I can use the =now() function to get the current time, it continually
updates, and all the =now() cells change (unsurprisingly) to the
current time. I want the time to remain the time I tapped the given
cell. Is there a convenient means to do this in Excel Mobile?

Thanks for your help.
Brian
 
G

Guest

I don't use that particulat software, but in regular Windows and Excel,
Ctrl semicolon = date
Ctrl Shift colon = time

Vaya con Diso,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Stamp 8
time stamp question 2
Time stamp 3
Date-time stamp 3
how do i set up a time stamp if another number entered in cell? 1
Mobile phone signals could be blocked in cars 24
Excel Mobile and VBA? 1
Auto Stamp Date 13

Top