G
Glenan
Hi all:
First of all, thank you in advance for anything that you may offer.
I have made a table in MS Word to keep track of my work hours. I am a
"Technical maintenance Technician" by job description and travel from
location to location. I have to keep track of how much time I spend at each
location.
The table has columns for the store number, date, time in, and time out.
Unless it's the beginning of a new day, the last "time out" is the next
"time in". Rather than entering the time in manually, does anybody know of
a formula I could use so that when I enter the "time out", it automatically
enters itself into the next "time in" cell?
Thanks again,
Glenn
First of all, thank you in advance for anything that you may offer.
I have made a table in MS Word to keep track of my work hours. I am a
"Technical maintenance Technician" by job description and travel from
location to location. I have to keep track of how much time I spend at each
location.
The table has columns for the store number, date, time in, and time out.
Unless it's the beginning of a new day, the last "time out" is the next
"time in". Rather than entering the time in manually, does anybody know of
a formula I could use so that when I enter the "time out", it automatically
enters itself into the next "time in" cell?
Thanks again,
Glenn