Time schedule between set time

[Olaf Jacobs]

Hi all, I'm breaking my mind over an time table that we use and can't see an option to get it solved.
We work in 12hr or 24hr operation, and to make an time estimate about the job and job progress during the job we would like to calculate this. During an 24hr operation the task of calculating is simple but as soon as i try to work this out during 12hr operation.

Where I'm trying to go is and 12hr system where the job only counts up between working time set in an other cel in this case working between 07:00 and 19:00, how can I adjust the formula in such way it starts counting the planned time between there.

Thanks for any help.

Book1.xlsx
	A	B	C	D	E	F	G	H
1		Forecast Input Sheet				Day	07:00	19:00
2	24					24hr	00:00	00:00
3	Start Time		Estimated hrs	Actual (hrs)	Comments
4	00:00 Tue 18 Feb	Pre preperation of the job and installation	16.00
5	16:00 Tue 18 Feb	Transport and offload installation	14.00
6	06:00 Wed 19 Feb	Rig up installation	26.00
7	08:00 Thu 20 Feb	Commision installation	6.00
8	14:00 Thu 20 Feb	Operational	8.00
9	22:00 Thu 20 Feb	Operational	6.00
10	04:00 Fri 21 Feb	Operational	14.00
11	18:00 Fri 21 Feb	Operational	5.00
12	23:00 Fri 21 Feb	Operational	0.50
13	23:30 Fri 21 Feb	Operational	6.00
14	05:30 Sat 22 Feb	Operational	0.50
15	06:00 Sat 22 Feb	Operational	18.00
16	00:00 Sun 23 Feb	Operational	0.75
17	00:45 Sun 23 Feb	Operational	28.00
18	04:45 Mon 24 Feb	Clean up location	6.00
19	10:45 Mon 24 Feb	rig down installation	21.00
20	07:45 Tue 25 Feb	Transport and backload installation	14.00
21	21:45 Tue 25 Feb
22	21:45 Tue 25 Feb
23	21:45 Tue 25 Feb
24	21:45 Tue 25 Feb
Input

Cell Formulas
Range	Formula
A5:A24	A5	=IF(D4>0,A4+D4/$A$2,A4+C4/$A$2)