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
Last edited by Dolly Parton : August 27th 12 at 09:06 PM
|