Is there an "easy way" to figure out hours worked?
Everything I do looks right until I try to calculate overtime.
Start time: 9:00am - Short Time
End time: 6:00pm -short time
Lunch start: 12:00pm -short time
Lunch End: 12:30pm - short time
Adjustments: 0:15pm -short time
[Total Hrs] = [end time]-[start time] - short time format
[pay hrs] = [total hrs]-([lunch end]-[lunch start])-[adustments] -short time format
the above works, however, this is where i have my problem:
[overtime]=[pay hrs]-8
I've spent hours on this, any help would be appreciated.
Thanks
Everything I do looks right until I try to calculate overtime.
Start time: 9:00am - Short Time
End time: 6:00pm -short time
Lunch start: 12:00pm -short time
Lunch End: 12:30pm - short time
Adjustments: 0:15pm -short time
[Total Hrs] = [end time]-[start time] - short time format
[pay hrs] = [total hrs]-([lunch end]-[lunch start])-[adustments] -short time format
the above works, however, this is where i have my problem:
[overtime]=[pay hrs]-8
I've spent hours on this, any help would be appreciated.
Thanks