MS Excel Formula Help

[CommSecy]

I have a "time sheet" with 55 members working various hours. Right now, I am manually entering the numbers in green, which is labor-intensive. I want to add a formula that will add only the hours that fall between 1500 and 0700.
Any help would be very much appreciated.

Thank you.

 

[CommSecy]

You can review this fragment that yields the number of hours.
You did not post an extract of your sheet that we can use.

Dates and Time 2024.xlsm
	C	D	E	F	G	H	I	J	K	L	M
1
2	10:00 PM	7:00 AM							09:00		7:00 AM
3											3:00 PM
4
4b

Cell Formulas
Range	Formula
K2	K2	=MOD(MIN(D2,M2)-MAX(C2,M3),1)

So it works on some, but say a schedule of 0700 - 1900 which should yield a result of 4 hours...it does not work

 

[Dave Patton]

You have to
* build the formulas for the different ranges of interest.
* consider the start and end times
* consider if the time spans midnight

I stated that the suggestion was a fragment for part of your requirement.

Review the suggestion and good luck with your project.

 

[CommSecy]

You have to
* build the formulas for the different ranges of interest.
* consider the start and end times
* consider if the time spans midnight

I stated that the suggestion was a fragment for part of your requirement.

Review the suggestion and good luck with your project.

Thank you,