How to use a date time stamp to determine the hour a call came in

[domil123]

I work at a call center and can extract the date time stamp of a call.  I need to know the busiest hours of the day.  I can format the date to only show the time, but if I then try to use an if statement it is looking at the complete value, not just the value in the formatted cell.  If I copy and past just the values, it still returns a numeric value.

[#2 · Accepted solution]

@domil123 

Let's say the time stamps are in D2 and down.

In another cell in row 2, enter the formula =MOD(D2,1) and format it as time if you want the time, or =HOUR(D2) if you only want the hour.

Then fill down.

[#3]

Thanks. Mod didn't work, but what I needed was HOUR and that worked great!