I am trying to use excel to enter information for each employee in a building
company according to where they have worked each day, and how many hours at
each location. The problem being I am not quite sure if I should or even can
use excel for this. Say on a Monday an employee did three hours at one
location, 5 at another and two at a third. How can I have a viable way of
entering informtion on one day which could have one through say 15 items of
data, totaling the hours altogether, and also totalling the hours for each
day, and for each location.

Although I am a new user, I do have a computer background. Any help would be
greatly appreciated.

Gary, Charminster Developments Ltd.

The easiest and most useful way to store this information would be in a
table with each column along the lines of
EmployeeID, Date, StartTime, Duration (or EndTime) LocationID, TaskID

How data are entered into the table depends on how easy you want to make
the task. The simplest approach would be to just add data in a new row
in the worksheet. You could also use XL's built-in Data| Form... or
John Walkenbach's enhanced version that you will find at www.j-walk.com.
Finally, you could create your user userform for the job.

This, of course, presumes you can store the information in XL. You may
also want to consider a program like MS Access. In addition to being a
real database program (better integrity checks of the data, real
relationships between tables, etc.) it also supports multiple concurrent
users.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article , =?Utf-
8?B?Q2hhcm1pbnN0ZXIgRGV2ZWxvcG1lbnRz?= <Charminster
says...
I am trying to use excel to enter information for each employee in a building
company according to where they have worked each day, and how many hours at
each location. The problem being I am not quite sure if I should or even can
use excel for this. Say on a Monday an employee did three hours at one
location, 5 at another and two at a third. How can I have a viable way of
entering informtion on one day which could have one through say 15 items of
data, totaling the hours altogether, and also totalling the hours for each
day, and for each location.

Although I am a new user, I do have a computer background. Any help would be
greatly appreciated.

Gary, Charminster Developments Ltd.

Yes appreciated. That is useful. I think it is time to migrate this task to
Access, which I have, a simple idea has become more complex than originally
envisaged as more uses suggested themselves.

"Tushar Mehta" wrote:

The easiest and most useful way to store this information would be in a
table with each column along the lines of
EmployeeID, Date, StartTime, Duration (or EndTime) LocationID, TaskID

How data are entered into the table depends on how easy you want to make
the task. The simplest approach would be to just add data in a new row
in the worksheet. You could also use XL's built-in Data| Form... or
John Walkenbach's enhanced version that you will find at www.j-walk.com.
Finally, you could create your user userform for the job.

This, of course, presumes you can store the information in XL. You may
also want to consider a program like MS Access. In addition to being a
real database program (better integrity checks of the data, real
relationships between tables, etc.) it also supports multiple concurrent
users.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article , =?Utf-
8?B?Q2hhcm1pbnN0ZXIgRGV2ZWxvcG1lbnRz?= <Charminster
says...
I am trying to use excel to enter information for each employee in a building
company according to where they have worked each day, and how many hours at
each location. The problem being I am not quite sure if I should or even can
use excel for this. Say on a Monday an employee did three hours at one
location, 5 at another and two at a third. How can I have a viable way of
entering informtion on one day which could have one through say 15 items of
data, totaling the hours altogether, and also totalling the hours for each
day, and for each location.

Although I am a new user, I do have a computer background. Any help would be
greatly appreciated.

Gary, Charminster Developments Ltd.