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

%3CLINGO-SUB%20id%3D%22lingo-sub-2768739%22%20slang%3D%22en-US%22%3EHow%20to%20use%20a%20date%20time%20stamp%20to%20determine%20the%20hour%20a%20call%20came%20in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2768739%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20at%20a%20call%20center%20and%20can%20extract%20the%20date%20time%20stamp%20of%20a%20call.%26nbsp%3B%20I%20need%20to%20know%20the%20busiest%20hours%20of%20the%20day.%26nbsp%3B%20I%20can%20format%20the%20date%20to%20only%20show%20the%20time%2C%20but%20if%20I%20then%20try%20to%20use%20an%20if%20statement%20it%20is%20looking%20at%20the%20complete%20value%2C%20not%20just%20the%20value%20in%20the%20formatted%20cell.%26nbsp%3B%20If%20I%20copy%20and%20past%20just%20the%20values%2C%20it%20still%20returns%20a%20numeric%20value.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2768739%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 Replies

@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.

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