If possible can a formula used to calculate employee payroll time in and out
be directed to follow certain conditions.

Ex: Employee (work schedule 9am-5pm)

TIME IN: 9:03 AM
TIME OUT: 4:49 PM

EXCEL FORMULA WILL CALCULATE THIS TIME IN HOURS
?- EMPLOYEE IS LATE CAN EXCEL BE CONDITIONED INPUT TIME IN TO THE FOLLOWING
QUARTER 9:15 AM
?- EMPLOYEE PUNCHED OUT EARLY THIS TIME CAN EXCEL GO BACK TO THE PREVIOUS
QUARTER

IN OTHER WORDS CAN THE FORMULA BEING TOLD TO CALCULATE FOR A 24 HOUR DAY BUT
CALCULATE TO AND BACK TO THE QUARTERS (15, 30, 75 AND ON THE HOUR)