N
Nananana
Hi.
Novice user, please have mercy.
Using Excel 2003.
I have start/end working hours. Examples:
A1 = 08:27:00
A2 = 17:21:00
B1 = 08:40:00
B2 = 17:50:00
And the required hours per day (09:00:00). Let's assume it's A7.
1. How can I calculate the working hours per day (A2-A1, B2-B1 etc.) ?
Let's assume it's A3, B3, etc.
2. How can I calculate the extra hours, positive or negative number:
A3 - A7, B3 - B7 ?
Thanks and regards,
Novice user, please have mercy.
Using Excel 2003.
I have start/end working hours. Examples:
A1 = 08:27:00
A2 = 17:21:00
B1 = 08:40:00
B2 = 17:50:00
And the required hours per day (09:00:00). Let's assume it's A7.
1. How can I calculate the working hours per day (A2-A1, B2-B1 etc.) ?
Let's assume it's A3, B3, etc.
2. How can I calculate the extra hours, positive or negative number:
A3 - A7, B3 - B7 ?
Thanks and regards,