Thread: Over time?
View Single Post
  #5   Report Post  
Dolly Parton Dolly Parton is offline
Junior Member
 
Posts: 3
Default

ok - its don't seem to be working out the 1.5/2.0 etc.

Answer to Assumption:
1. I agree. Remove the Date and day and the start time includes all:

dddd dd/mm/yyyy hh:mm
And i will create a new entry when i go past 23.59.



2. I presume "Break" is also in the form h:mm. YES

It would be better if we had
"start break" and "end break" times; and even better if they included the
date.

ADDED "start break" and "end break" times;


3. What's the difference between "total hours" and "overall time"? I
suspect the latter is intended to be the "time factor" that can be
multiplied by hourly wage.
Wanted a figure which excluded the 1.5/2.0 calculations and overall time to include 1.5 and 2.0


4. You have two columns identified as E1. - Typo.


5. I assume the above are titles in row 1, and the data starts in row 2. Yes


Ive attached - rename to from txt to .xlsx
Attached Files
File Type: txt test.txt (10.4 KB, 85 views)

Last edited by Dolly Parton : August 27th 12 at 09:06 PM