Need help figuring out excel formula with time.

[umdiddy098]

So I am trying to figure out a way to calculate total hours worked. The only issue is the hours worked is 15.5 hours day's (6:30AM to 10:00pm on weekdays) and it is for specific task. I am trying to calculate productivity based on the task. I will post a example below.
Start time: 6:30am Start date: 5/1/23
End Time:10:00pm End date: 5/2/23
Downtime: 60 min, Work week hours: 6:30am to 10:00pm
I need a formula that can calculate the total hours worked within multiple days that subtracts the downtime (min.).

I have tried writing this complicated "if" formula out but can't get it.

Any help would be great!

 

[ExceLoki]

try this and see if it works for what you're looking for

Book1
	A	B	C	D	E	F	G
1	start time	start date	end time	end date	downtime		Hours for all days
2	6:30 AM	5/1/2023	10:00 PM	5/2/2023	60		27.00
Sheet1

Cell Formulas
Range	Formula
G2	G2	=(((C2-A2)*1440-(E2*(D2-B2+1)))/60)*(D2-B2+1)