My Work Clock

Frequently asked questions:

How do I add/edit/delete existing punch-in/out?
How to handle different income by shift/weekends/holidays?
How to use the job time settings?
How to use job overtime settings?
How do I export data?
How do I set multiple default recipients?
Where the backup are stored? How the auto-backup works? How to restore backup?
How does the lunch break works?
How do I add a widget?
How do I get nice hours display in Excel?
How do I open the backup DB files on my PC?

Note: The dollar sign ('$') in this document is given only for example. The application is currency independent.

How do I add/edit/delete existing punch-in/out?

On the main application screen click 'Menu' -> 'Manage Records'.

How to handle different income by shift/weekends/holidays?

I'm making 10$/h for day shift & 20$/h for night shift
- Use multiple jobs, set each shift as it's own job. When entering day shift, punch in on job 'Day Shift', and on nigth shift punch-in on job 'Night Shift'. When viewing report, view all jobs together.
I'm making 10$/h on weekdays & 20$/h on the weekends/holidays
- Same as above, use multiple jobs, one for the weekdays and one for the weekends.

How to use the job time settings?

The job time setting are used to set individual job time frame. The default setting is probably good for most people (days are midnight to midnight, week start on Monday, month start on the 1st of the month).
- First hour of day - Relevant to all time settings, most people should not change this. By default a day is calculated from 00:00 to 23:59. People who work night shift should set the 'First hour of day' to noon so if the punch-in/out in the middle of the shift it will be counted in the same day. For example, if it is set to 10:00am, Monday will be: Monday 10:00am-Tuesday 10:00am
- First day of week - Relevant only for weekly settings (weekly, bi-weekly, 4-weekly). Set this to the day you week starts on. Some jobs pay week starts on Tuesday other on Sunday.
- First day of month - Relevant only for monthly settings. Set this to the day of the month you work month starts on. For example, if you work month starts on the 10th (e.g. Feb 10th-Mar 9th), set this to 10.
- Shift bi-weekly week - Relevant only for bi-weeks. Bi-week can start this week or last week. If the default setting does not fit your bi-week change it here.
- Shift 4-weekly week - Relevant only for 4-weekly setting. Similar to bi-weekly week shift.

How to use job overtime settings? Overtime examples

I'm paid 10$/h for the first 8 hours a day, 15$/h for every hour after that

Set:
Hourly wage: 10
Overtime Period: Daily
Hours before overtime 1: 8
Overtime 1 hourly wage: 15
Leave all other overtime fields empty

I'm paid 10$/h for the first 40 hours a week, 15$/h for every hour after that

Set:
Hourly wage: 10
Overtime Period: Weekly
Hours before overtime 1: 40
Overtime 1 hourly wage: 15
Leave all other overtime fields empty

I'm paid 10$/h for the first 8 hours a day, 15$/h for the following 2 hours and 20$/h for every hour after that

Set:
Hourly wage: 10
Overtime Period: Daily
Hours before overtime 1: 8
Overtime 1 hourly wage: 15
Hours before overtime 2: 2
Overtime 2 hourly wage: 20

I'm paid 10$ for every hour, plus 15$ for every day I'm working

Set the daily payment in the first hour, and the hourly income as overtime:
Hourly wage: 25
Overtime Period: Daily
Hours before overtime 1: 1
Overtime 1 hourly wage: 10

How do I export data?

To export summarized reports:
1. Click 'Menu' and open the 'Reports' screen.
2. Select the report (and possibly job) needed
3. Click 'Menu' and select 'Export CSV'
To export full records data including description:
1. Click 'Menu' and open the 'Manage Records' screen.
2. [Multiple jobs only] Select the job needed
3. Click 'Menu' and select 'Export CSV'

How do I set multiple default recipients?

To set multiple default recipients use semicolon to seperate between e-mail addresses, e.g.: "test1@gmail.com;test2@gmail.com"

Where the backup are stored? How the auto-backup works? How to restore?

The backups are stored in an internal folder accessible only by the app. By default the application creates a backup of the database everyday, after a punch-out. There is an automated process that deletes old backups.
IMPORTANT: We highly recommend using the backup to e-mail option so there will be a backup off the device.
The backup files (*.DB) are stored in Android SQLite format (binary format). They might be opened using 3rd party tools, however it is not recommended. If you need access to the raw data open the 'Manage Records' screen ('Menu'->'Manage Records') and send the records as CSV ('Menu'->'Send CSV').
To restore from a database sent by e-mail save it on the device and click 'Restore from file'.

How does the lunch break works?

The lunch break button performs punch-out & punch-in with the given break period. For example:

The lunch break setting is checked, and the lunch break drop down is set to 30 minutes.
You check in at 08:00
You Press 'Lunch Break (30 min)' at 12:30. This adds check-out at 12:00, an checks-in 12:30.
The following records are created:
08:00 - 12:00
12:30 -

How do I add a widget?

Find an empty location on the device desktop, long-click the empty location until a menu pops up, select "Widgets", scroll down to "My Work Clock" and click it.

How do I get nice hours display in Excel?

The export to excel exports the real time (in seconds), dividing it by 3600 will give you exact hours (e.g. 6300/3600 = 1.75), to get nice hours display (1:45) use the following formula: =INT(A1) & ":" & INT((A1-INT(A1))*60)

How do I open the backup DB files on my PC?

The backup DB files are SQLite database files. Any SQLite database files viewer can open them, for example: SQLite database browser.
If you just want to view with the raw data, there are multiple options in the application to send it as CSV (which is viewable using MS-Excel, Google Docs, etc.).