You enter the actual time in cell A1 and cell B1 contains you're rounding
formula?

--
Biff
Microsoft Excel MVP


"LJustice" wrote in message
...
So, I have the formula to round my time entered...but is it possible to
enter
the time into the cell with the formula to round the time? I'm trying to
make
a timesheet, and can't figure out how they could input their time, and it
would automatically change to the correct rounded time.