Newbie needs some help

[greg123]

I am creating a timesheet and am trying to make it calculate normal time overtime and double time in hours.

I have start time in A1 (6:00)
Break time in A2 (00:30 minutes) which is deducted
Finish time in A3 (18:00)

In A4 I want to have it auto calculate normal time only with a max of 8 hours (in this case it would display the Maximum 8)
in A5 I want to calculate overtime hours with a max of 2 hours (in this case it would display the max 2)
in A6 I want it to show the remaining hours for double time (in this case it would 1 and a half)


can someone tell me how to do this?

[jeffreybrown]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.