I have designed a time sheet for payroll purposes that automatically
calculates all appropriate formulas. The only one I haven't figured out yet
is this: in my office, we follow the seven minute rule in that when
calculating time, every clock in and clock out time is rounded to the nearest
quarter hour. Currently, my time sheet sums up the total time for each day.
I need a formula that then rounds that total time that is listed to the
nearest quarter hour (whether up or down). Can anyone help me out.