Sep 20 2021 02:12 PM
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.
Sep 20 2021 02:16 PM
SolutionLet'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.
Sep 21 2021 05:56 AM
Sep 20 2021 02:16 PM
SolutionLet'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.