Anyone knows a formula that can round of 7:55am to 8:00am? I also need the formula to show if the employee is late also. So if the aget clock in before their shift start then the formula round it of to the start time however if the agent is late then the time remain as it is.

eg:

Shelly logged in 7:58am the formula would then round it of to 8:00am

if shellys logged in at 8:02am then the formula keeps the time at 8:02am.


Is there a way to do this....i've been trying for hours.