Forum Discussion
Solved
How to use a date time stamp to determine the hour a call came in
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.
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.
2 Replies
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.
- Thanks. Mod didn't work, but what I needed was HOUR and that worked great!
