I am hoping to use a formula to capture clock-in time for employees. Intended functionality is that if the box is checked, log the shift start time as actual start time. If the box is unchecked, override the shift start time with actual time captured in another column. Search results said the formula to use is IF({Checked in on time?}, {Shift Start}, {Check in time if late}). The formula captures a time, but it does not match either date field.

Any thoughts on why the formula is miscalculating?