Excel Time Sheet |
Top Previous Next |
Email an Excel Time Sheet to yourself or an employee so they may enter their time into it. Once they are finished, they can send the file back so that you can Import it into the Design Manager Employee Time.
There are two areas within the program to do so:
Employee Time Window
A message will appear to show the Employee and Date range of the file to be emailed.
An Email message will appear as shown below.
To change the default Excel file, see Company Advanced Options Window - Time Tab.
***NOTE: The default Excel Time Sheet can be opened and manipulated within Microsoft Excel (recommended). If you do not have Excel, we have found that the file can also be edited in Google Docs/Sheets. Numbers does not appear to be compatible with the defaulted Excel Sheet as its field validation is too complex for the program. You can, however, create your own file within Numbers that does not include such complexities.***
Here the user can enter their time. Users can select from the Drop down options for Projects & Activities. The active Projects & Activities from your Design Manager will appear. Once the user has completed entering their time, they can Import this file (or send the file back to another user to Import for them).
To Import the file, see Import Data (Time).
An Email message for each Employee tagged will be sent automatically. The email will an include an Excel file attachment that can be opened and saved in Excel. The Excel file will appear as below:
Here the user can enter their time. Users can select from the drop down options for Projects & Activities. The active Projects & Activities from your Design Manager will appear.
Once the user has completed entering their time, they can Import this file (or send the file back to another user to Import for them).
To Import the file, see Import Data (Time).
|