Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 44

How do I round time

I would like to know how to round five minutes to an hour and five minutes
after the hour to the nearest whole hour. (ex. round 7:55 and 8:05 to 8:00)

Thanks,

Ana

Reply With Quote

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 time to the nearest half a minute	ALEX	Excel Discussion (Misc queries)	3	September 25th 06 11:25 PM
Round Time to 30 minutes	Shiv	Excel Worksheet Functions	1	March 10th 06 03:21 PM
Round up a time to the next 15 minutes	Frederick Chow	Excel Worksheet Functions	5	March 5th 06 10:41 AM
Excel Time Manipulation	BFiedler	Excel Discussion (Misc queries)	0	September 15th 05 01:15 AM
Round Up Time IF	carl	Excel Worksheet Functions	4	January 7th 05 07:25 PM

All times are GMT +1. The time now is 06:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us