|
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 |
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 |
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 |
| All times are GMT +1. The time now is 09:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com