Google Sheets - TimeValue Between 2 Dates

[sprigelz]

Good afternoon,

I am trying to get a timevalue between 2 dates. I was able to find and implement the below formula, but this just looks at the "Duration" column as a whole and doesn't have the date check.

=arrayformula(text(sum(iferror(timevalue('Hunting Log'!C2:C3))),"[h]:mm:ss"))

Start Date is in cell D3
End Date is in cell D4

The above formula works perfectly fine, like I said just trying to add the additional function to it. Should look in Hunting Log B:B for date data.

 

[ExceLoki]

below is my table copied from gsheets:
i have the bottom row formatted as duration
you could use either d5 as is, or if your date and time are separate use g5

	C	D	E	F	G
3	start	3/12/2023 4:31:01 PM	3/12/2023	4:31:01 PM
4	end	3/15/2023 8:59:00 AM	3/15/2023	8:59:00 AM
5		2:41:10	3:00:00	-0:18:50	2:41:10

here is in excel w/ the same formulas:

Book1
	C	D	E	F	G
3	start	3/12/23 4:31 PM	3/12/2023	4:31:01 PM
4	end	3/15/23 8:59 AM	3/15/2023	8:59:00 AM
5		2:41:10	3:00:00	-0.013079	2:41:10
Sheet1

Cell Formulas
Range	Formula
D5:F5	D5	=(D4-D3)/24
G5	G5	=E5+F5

 

[sprigelz]

Hmm, that's not exactly how I have it set-up.

#	Date	Time Spent (Duration)
1	14-Mar-2023	3:43:40
2	15-Mar-2023	2:30:58

On another tab I am building a dashboard with the total month values. So I need something that looks between 1 Mar - 31 Mar and adds the "Time Spent (Duration)" column.

The previously linked, and listed formula below, works perfectly fine for what I want it to do. Only problem is it does not look between those 2 dates. So I would have to manually adjust a part of the function for each month.

=arrayformula(text(sum(iferror(timevalue('Hunting Log'!C2:C3))),"[h]:mm:ss"))

 

[ExceLoki]

can you give more fo an example of what you have and what you're looking for?
or as this is google sheets, if you want to make a shared un-editable copy, could look at what you have

 

[sprigelz]

Sorry, didn't even think about just providing a link!

Link to Sheet