Can you give some examples of your input date-time along with expected results.
[CL Time Sent] = 9:32 AM --> 10:00 AM
[CL Time Sent] = 9:05 AM --> 9:00 AM
I'm trying to create hour bins that round times with minutes <= 30 to the previous whole hour, and times with minutes >= 30 to the following full hour.
Create these three fields:
IF [Minute]<=30 THEN
Your time is in string format not in Datetime format. Please post this workbook. Need to check.
Doh! Rookie mistake.
Thank you so much!