calculating daily production

[orsm6]

Hi all - trying to work out how to calculate some production data.

I know:
- how many units were made in the run
- how many units are made an hour

almost always the product might run across more than 1 day - so as example it started at 1/1/21 00:00 and finished 3/1/21 10:00 and produced 110,000 units....


what i can't work out is a formula that can workout each day how many units were made.... would anyone be able to help?

not sure what info i would need to provide to help, so please let me know.
TIA

 

[etaf]

you need to multiply the time by 24
=110000/((B1-A1)*24)

Book3
	A	B	C	D	E
1	1/1/21 0:00	1/3/21 10:00	58:00:00	100000	1724.13793
Sheet1

Cell Formulas
Range	Formula
C1	C1	=B1-A1
E1	E1	=D1/((B1-A1)*24)

this gives you per hour
then * 24 to get each 24hour day

Book3
	A	B	C	D	E	F
1	1/1/21 0:00	1/3/21 10:00	58:00:00	100000	1724.13793	41379.3103
Sheet1

Cell Formulas
Range	Formula
C1	C1	=B1-A1
E1	E1	=D1/((B1-A1)*24)
F1	F1	=E1*24