Posted to microsoft.public.excel.misc

external usenet poster

Posts: 493

how do i round time to the nearest half a minute

is it possible??
e.g.
i have a list of times

01:05:28 round to 01:05:30
01:05:45 round to 01:06:00

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how do I round hours worked to the next half hour with a 24hr shif	gycoso3	Excel Worksheet Functions	1	March 28th 06 09:25 PM
... round a time entry to the next "30 minute increment"...	Dr. Darrell	Excel Worksheet Functions	12	February 3rd 06 04:09 PM
Round Up to Nearest 10	Marek	Excel Worksheet Functions	4	April 29th 05 01:16 PM
Round Time	cpme	Excel Worksheet Functions	2	November 18th 04 07:09 PM
How do I round time?	cpme	Excel Worksheet Functions	3	November 17th 04 12:37 AM

All times are GMT +1. The time now is 11:07 PM.

About Us

"It's about Microsoft Excel"