Skip to Content
0
Jan 10, 2023 at 11:07 PM

midpoint of two times over 24 hours

30 Views

I'm trying to write a report that will give me the midpoint between two datetime fields. How can this be done?

Example #1:

if the first datetime field is 04/10/02 09:00:00AM and second is 04/10/02 10:00:00AM, then I want the midpoint to be 04/10/02 09:30:00AM

Example #2:

if the first datetime field is 04/09/02 11:00:00PM and second is 04/10/02 03:00:00AM, then I want the midpoint to be 04/10/02 01:00:00AM

Thanks in advance!