Now any time would be rounded to the next 15 min slot. HOURS are extracted simply using the HOUR FUNCTION which will give the number of hours from the given time.Īs we need to round off the minutes, we use the function CEILING.MATH in which we put the inputs and have given the significance of 15 minutes, seconds are zero. We started with the outer function TIME, which would take three inputs as HOUR, MINUTES and SECONDS.
#How to use excel student schedule trial
It is quite obvious because when we don’t know the exact working of any system or process, we try to use it just by hit and trial method.