Hi All,

New user here and first post. I have a decent understanding of excel but was wondering if someone with a bit more knowledge can help on a small issue im having.

We get a monthly report in excel which shows who has been in and out of our building and this has time stamps on each user who enters/exits. What i would like to know is, is there a formula which will calculate the time a user comes in and allocate an interval time to it?

For e.g. We have 2 columns from this excel sheet, one is called "Time", the next is called "Interval". If we have 2 users, User A comes in at 09:32:45 - the interval I would like this to be; 09:30-18:00 (09:30 being the start time and 18:00 being the finishing time of the company), User B comes in at 09:05:26 - the interval for this would be 09:00-09:30.

Is it possible to have excel detect the times from the "Time" column and assign the appropriate interval to this? Would be great as i am currently having to do this manually.

Thanks,
Has