An app to track your hours worked (clock in & clock out times)?

sausage_time

Grumpy_chap said:

B0bbyEwing said:

So if I clock on at 8:57 and clock off at 5:06 then we will get paid from 9:00 - 5:00 with 30mins deducted for dinner so that's 8 hours at work but 7.5 hours pay.

sausage_time said:

If you are willing to invest a little time in Google Sheets you can make exactly what you need.

• Google Sheets app (Android) remembers the sheet location when you open up - no need to scroll.
• If you format cells as "time", when you edit to enter data there is a floating clock icon.  If you click this it loads the current time into that cell.
• If you have one column for Start (A10 say), another for finish (B10 say), you can have a third (probably C10) which calculates the duration (B10-A10) - also formatted as time.
• You can even deduct your dinner - (B10-A10)-"0:30:00" will do that.

The part of the app that does the time calculation would need to include the rounding up (at start of day) to the next 15-minute (or whatever) increment and the rounding down (at end of day) to the end of the previous 15-minute increment.  Only then can the hours worked be calculated.

In that case, to continue the previous example cell C10 becomes

=FLOOR(B10,"0:15")-CEILING(A10,"0:15")-"0:30"

CEILING rounds the start time to the next whole 15 mins, FLOOR rounds the finish to the previous 15 minute increment.

sausage_time

B0bbyEwing said:

So if I clock on at 8:57 and clock off at 5:06 then we will get paid from 9:00 - 5:00 with 30mins deducted for dinner so that's 8 hours at work but 7.5 hours pay.

And here is your example using those equations!



For a real worksheet you would likely extend the equation over rows, one per working day or shift.

Grumpy_chap

sausage_time said:

Grumpy_chap said:

B0bbyEwing said:

So if I clock on at 8:57 and clock off at 5:06 then we will get paid from 9:00 - 5:00 with 30mins deducted for dinner so that's 8 hours at work but 7.5 hours pay.

sausage_time said:

If you are willing to invest a little time in Google Sheets you can make exactly what you need.

• Google Sheets app (Android) remembers the sheet location when you open up - no need to scroll.
• If you format cells as "time", when you edit to enter data there is a floating clock icon.  If you click this it loads the current time into that cell.
• If you have one column for Start (A10 say), another for finish (B10 say), you can have a third (probably C10) which calculates the duration (B10-A10) - also formatted as time.
• You can even deduct your dinner - (B10-A10)-"0:30:00" will do that.

The part of the app that does the time calculation would need to include the rounding up (at start of day) to the next 15-minute (or whatever) increment and the rounding down (at end of day) to the end of the previous 15-minute increment.  Only then can the hours worked be calculated.

In that case, to continue the previous example cell C10 becomes

=FLOOR(B10,"0:15")-CEILING(A10,"0:15")-"0:30"

CEILING rounds the start time to the next whole 15 mins, FLOOR rounds the finish to the previous 15 minute increment.

Thank you - I was unaware of the "FLOOR" and "CEILING" functions.

EDIT - that does not seem to work in excel.  Are they functions only in Google Sheets?

sausage_time

Grumpy_chap said:

sausage_time said:

Grumpy_chap said:

B0bbyEwing said:

So if I clock on at 8:57 and clock off at 5:06 then we will get paid from 9:00 - 5:00 with 30mins deducted for dinner so that's 8 hours at work but 7.5 hours pay.

sausage_time said:

If you are willing to invest a little time in Google Sheets you can make exactly what you need.

• Google Sheets app (Android) remembers the sheet location when you open up - no need to scroll.
• If you format cells as "time", when you edit to enter data there is a floating clock icon.  If you click this it loads the current time into that cell.
• If you have one column for Start (A10 say), another for finish (B10 say), you can have a third (probably C10) which calculates the duration (B10-A10) - also formatted as time.
• You can even deduct your dinner - (B10-A10)-"0:30:00" will do that.

The part of the app that does the time calculation would need to include the rounding up (at start of day) to the next 15-minute (or whatever) increment and the rounding down (at end of day) to the end of the previous 15-minute increment.  Only then can the hours worked be calculated.

In that case, to continue the previous example cell C10 becomes

=FLOOR(B10,"0:15")-CEILING(A10,"0:15")-"0:30"

CEILING rounds the start time to the next whole 15 mins, FLOOR rounds the finish to the previous 15 minute increment.

Thank you - I was unaware of the "FLOOR" and "CEILING" functions.

EDIT - that does not seem to work in excel.  Are they functions only in Google Sheets?
 

FLOOR and CEILING are supported in Excel I believe.  Perhaps Excel does not like the "0:15" notation and you may have to use the less readable TIME(0,15,0) instead?  I don't use Excel so can't check 

kimwp

You could also hide the rows that you don't need to look at any more so you don't need to scroll down. 

Or group them so you can click to expand and contract.

B0bbyEwing

Looks like a bit of learning would be required. Never heard of floor & ceiling in this sense so wouldn't have even known where to begin with that without asking the question.

Would it do this though....

So say I clock on at 9:01, 9:02 or 9:03 .... I should get paid from 9:00. 9:04-9:17 would be paid as though I started at 9:15.

Clocking off is a weird one. Years ago we got told that if we worked half way in to the 15min segment then we get  that 15min segment. This some times worked but usually didn't so I stopped challenging it every time I was underpaid & just assumed I would never get it (for say 5:08 should get us paid to 5:15).

If you clock off at 10mins in to the 15min segment then 9 times out of 10 you will get it but it's not a cert.

We had this new person once who was brought in to do payroll. I frequently got incorrect pay when she was managing it & she said the reasoning was that I should clock off within 3mins of the 15min segment (so 5:11 would be 11mins of unpaid work but 5:12 would get me paid to 5:15). This woman was overruled by the previous payroll person who had more authority but I'm mentioning it because 1) it happened and 2) I'm trying to show you the goal posts move depending on which way the wind is blowing on that particular day. You'll tell me it shouldn't, I'll agree with you but that's just how it is.

Obviously there's only 1 way to guarantee payment & that's stay until the 15min segment is complete. Unfortunately that can have you 'hanging around' and if you get clocked doing that then people have in the past been refused payment for that 15min segment. 

sausage_time

Your clarification on start time is clear enough.

So say I clock on at 9:01, 9:02 or 9:03 .... I should get paid from 9:00. 9:04-9:17 would be paid as though I started at 9:15.

This should give you what you want.

=CEILING(Start-"0:03","0:15")

Where Start is the cell with the actual start time.  In words, "If Start is more than 3 minutes after the 15 minute segment round to the next 15 minute segment".

The finish calculation is less clear to me.  If we take it as "If Start is more than 12 minutes after the 15 minute segment round to the next 15 minute segment" then you could use:

=CEILING(Finish-"0:12","0:15")

Put together here are some sample entires for next week:



With equations turned on so you can see how this works:



If that's not quite what you want it can easily be customised.  

rdr

Gleeo time tracker will do this, the free version will cover your needs
PRICING

B0bbyEwing

rdr said:

Gleeo time tracker will do this, the free version will cover your needs
PRICING

Searched pricing in Google Play Store.

Didn't seem to return anything.