#1   Report Post  
Posted to microsoft.public.excel.misc
PS PS is offline
external usenet poster
 
Posts: 18
Default Timestamp

I would to timestanp a excel sheet that I use for work. It my have 10 jod
sites to go to in a day. I log in (time) and log out (time) at each stop. I
need the timestamp each cell.
--
Thanks, PS
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Timestamp

One way ..

Try JE McGimpsey's coverage of "Time and date stamps" at his page:
http://www.mcgimpsey.com/excel/timestamp.html

Here's a sample file from my archives
(with JE's sub implemented):
http://savefile.com/files/41920
Date_Time_Stamping.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
PS wrote:
I would to timestanp a excel sheet that I use for work. It my have 10 jod
sites to go to in a day. I log in (time) and log out (time) at each stop. I
need the timestamp each cell.
--
Thanks, PS


  #3   Report Post  
Posted to microsoft.public.excel.misc
PS PS is offline
external usenet poster
 
Posts: 18
Default Timestamp

It looks as if it will work for me. I'll try it later today.
--
Thanks, PS


"Max" wrote:

One way ..

Try JE McGimpsey's coverage of "Time and date stamps" at his page:
http://www.mcgimpsey.com/excel/timestamp.html

Here's a sample file from my archives
(with JE's sub implemented):
http://savefile.com/files/41920
Date_Time_Stamping.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
PS wrote:
I would to timestanp a excel sheet that I use for work. It my have 10 jod
sites to go to in a day. I log in (time) and log out (time) at each stop. I
need the timestamp each cell.
--
Thanks, PS



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Now as timestamp Lp12 Excel Worksheet Functions 5 August 13th 06 11:32 AM
synchronizing timestamp feature with time on video software. 999 Excel Discussion (Misc queries) 4 July 30th 06 10:49 PM
Excel formula timestamp for a data entry of a referenced cell jmasaki Excel Worksheet Functions 1 July 3rd 06 02:19 AM
Timestamp Macro alexfthe Excel Worksheet Functions 1 March 12th 06 11:39 PM
Timestamp Button Eckleburg Excel Discussion (Misc queries) 2 June 6th 05 04:52 PM


All times are GMT +1. The time now is 04:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"