time sheet help

[jamieraebaby]

I use excel for payroll. How can make a cell round to the neares
quarter of an hour. Like if I type 1:17 PM it will read 1:15 Pm or if
type 7:42 AM it will read 7:45 AM. please help

 

[Bob Phillips]

See response in public.excel.

--
HTH

Bob Phillips

"jamieraebaby" <[email protected]>
wrote in message
news:[email protected]...