time sheet help

[jamieraebaby]

I use excel for payroll. How can make a cell round to the nearest quarter of an hour. Like if I type 1:17 PM it will read 1:15 Pm or if i 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]...
>
> I use excel for payroll. How can make a cell round to the nearest
> quarter of an hour. Like if I type 1:17 PM it will read 1:15 Pm or if i
> type 7:42 AM it will read 7:45 AM. please help.
>
>
> --
> jamieraebaby
> ------------------------------------------------------------------------
> jamieraebaby's Profile:
http://www.excelforum.com/member.php...o&userid=27855
> View this thread: http://www.excelforum.com/showthread...hreadid=475257
>