Hi,

I am trying to calculate the time difference between two time intervals.

For example, I have some number of people coming between 23:30 and 0:00. The same way for some more intervals starting from 22:00 till 2:00.

My Task is to find out how many number of people are coming in, in each half hour interval.

I was able to get this number successfully from 22:00 till 23:30.

But when the time filps i.e., from 23:30 to 0:00, I am not able to do it.

Is there any way to accomplis this?

Regards,
Anjani Kumar

Hi Anjani,
welcome to UA Forums! (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)

try this out:

=IF(B1<A1,B1-A1+1,B1-A1)

A1 is start, B1 end of your interval

(IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)
Martin