Hours Worked

[Nana Arhin]

Working hours for Mawuli Tettey (Dec 2022)
Date	Time in	Time out	Number of hours
01/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
02/12/2022​	6:00:00 PM​	9:08:00 PM​	3.13​
03/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
04/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
05/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
06/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
07/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
08/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
10/12/2022​	6:00:00 PM​	6:00:00 AM​	12.00​
11/12/2022​	6:00:00 PM​	6:00:00 AM​	12.00​
12/12/2022​	6:00:00 PM​	6:00:00 AM​	12.00​
13/12/2022​	6:00:00 PM​	6:00:00 AM​	12.00​
15/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
16/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
17/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
18/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
19/12/2022​	6:00:00 PM​	6:00:00 AM​	12.00​
20/12/2022​	6:00:00 PM​	6:00:00 AM​	12.00​
21/12/2022​	6:00:00 PM​	6:00:00 AM​	12.00​
23/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
24/12/2022​	6:00:00 PM​	6:00:00 AM​	12.00​
25/12/2022​	6:00:00 PM​	6:00:00 AM​	12.00​
26/12/2022​	6:00:00 PM​	6:00:00 AM​	12.00​
28/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
29/12/2022​	6:00:00 AM​	6:00:00 PM​	12.00​
30/12/2022​	6:00:00 PM​	6:00:00 AM​	12.00​
Total working hours			303.13​

 

[Dave Patton]

what is your question?
Where is your concern?
N.B. Your post is just text. It is much better if you post your information with the forum's tool named XL2BB.

T202301a.xlsm
	A	B	C	D
1
2	Date	Time in	Time out	Number of hours
3		06:00:00 AM	06:00:00 PM	12.00
4		06:00:00 PM	09:08:00 PM	3.13
5		06:00:00 PM	06:00:00 AM	12.00
6		06:00:00 PM	04:00:00 AM	10.00
7	Total working hours			37.13
1c

Cell Formulas
Range	Formula
C3	C3	=B4
D3:D6	D3	=(C3-B3+(B3>C3))*24
D7	D7	=SUM(D3:D6)

 

[Nana Arhin]

what is your question?
Where is your concern?
N.B. Your post is just text. It is much better if you post your information with the forum's tool named XL2BB.

T202301a.xlsm
	A	B	C	D
1
2	Date	Time in	Time out	Number of hours
3		06:00:00 AM	06:00:00 PM	12.00
4		06:00:00 PM	09:08:00 PM	3.13
5		06:00:00 PM	06:00:00 AM	12.00
6		06:00:00 PM	04:00:00 AM	10.00
7	Total working hours			37.13
1c

Cell Formulas
Range	Formula
C3	C3	=B4
D3:D6	D3	=(C3-B3+(B3>C3))*24
D7	D7	=SUM(D3:D6)

I used time 2 - Time 1 *24. but i get negative results when the staff worked overnight.

 

[Nana Arhin]

I used time 2 - Time 1 *24. but i get negative results when the staff worked overnight.

I am trying to download XL2bb but it's not compatible with "protected view" on my excel. Thank you.

 

[Nana Arhin]

what is your question?
Where is your concern?
N.B. Your post is just text. It is much better if you post your information with the forum's tool named XL2BB.

T202301a.xlsm
	A	B	C	D
1
2	Date	Time in	Time out	Number of hours
3		06:00:00 AM	06:00:00 PM	12.00
4		06:00:00 PM	09:08:00 PM	3.13
5		06:00:00 PM	06:00:00 AM	12.00
6		06:00:00 PM	04:00:00 AM	10.00
7	Total working hours			37.13
1c

Cell Formulas
Range	Formula
C3	C3	=B4
D3:D6	D3	=(C3-B3+(B3>C3))*24
D7	D7	=SUM(D3:D6)

It worked thank you.