Calculating time for contract workers

[DPChristman]

Looking for a good formula to calculate work hours.

I can create a simple D-C formula to get the daily hours, b ut the problem comes when I need to calculate total hours for the week.

I know it's something simple, I just can't think of it.

 

[Asbestos_Jen]

The total for the week should just be the sum of the individual days, unless I'm misunderstanding your request. Use a custom number format [h]:mm.

2024-08-14.xlsx
	A	B	C	D	E	F
1
2	Day	Date	Start	End	Total
3	Sun	18-Aug-24	08:30	16:30	08:00
4	Mon	19-Aug-24	08:30	16:30	08:00
5	Tue	20-Aug-24	08:30	16:30	08:00
6	Wed	21-Aug-24	08:30	16:30	08:00
7	Thu	22-Aug-24	08:30	16:30	08:00	W/E: 08/24
8	Fri	23-Aug-24	08:30	16:30	08:00	TOTAL
9	Sat	24-Aug-24	08:30	16:30	08:00	56:00
10	Sun	25-Aug-24			00:00
11	Mon	26-Aug-24	08:30	16:30	08:00
12	Tue	27-Aug-24	08:30	16:30	08:00
13	Wed	28-Aug-24	08:30	16:30	08:00
14	Thu	29-Aug-24	08:30	16:30	08:00	W/E: 08/31
15	Fri	30-Aug-24	08:30	16:30	08:00	TOTAL
16	Sat	31-Aug-24			00:00	40:00
17	Sun	1-Sep-24			00:00
18	Mon	2-Sep-24			00:00
19	Tue	3-Sep-24	08:30	16:30	08:00
20	Wed	4-Sep-24	08:30	16:30	08:00
21	Thu	5-Sep-24	08:30	16:30	08:00	W/E: 09/07
22	Fri	6-Sep-24	08:30	16:30	08:00	TOTAL
23	Sat	7-Sep-24	08:30	16:30	08:00	40:00
Sheet1

Cell Formulas
Range	Formula
F7,F21,F14	F7	="W/E: "&TEXT(B9,"mm/dd")
F9,F23,F16	F9	=SUM(E3:E9)
E3:E23	E3	=D3-C3
A3:A23	A3	=TEXT(WEEKDAY(B3),"Ddd")

 

[DPChristman]

That does not work. For some reason F9, f16,f23 is not adding the hours correctly. See attached

 

[Asbestos_Jen]

That does not work. For some reason F9, f16,f23 is not adding the hours correctly. See attached

Please check that all of your times are values (set format to number) and not text.

It worked in my version, and I can't really diagnose what's wrong with yours from a picture. This is what mine looks like when I changed the format to number for all cells.

 

[NoSparks]

@DPChristman
Make your E column hours instead of clock time
=(D3-C3)*24