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
 
C

CLR

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

Word macro that can call cells out of Excel for a find and replace 0
Why no Outlook Mobile for Windows Mobile??? 2
Opeing older files in Excel 2007 - file date-stamp amended 0
how do i set up a time stamp if another number entered in cell? 2
Problem recording entry time 4
Excel Bug 0
Time/Date Stamp 3
Process a Time Stamp 2

Top