Posted to microsoft.public.excel.newusers

Meghan

external usenet poster

Posts: 8

How do I round time to the nearest quarter of an hour

I am not too understanding of excel to any great extent. But I need to round
time to the nearest quarter.

Example

8:11 to 8.25
4:41 to 4.75

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
Rounding to the nearest quarter point?	George	Excel Discussion (Misc queries)	3	June 10th 06 10:12 PM
how to calculate time start & time finish in quarter hour	Peter Wu	Excel Discussion (Misc queries)	3	June 7th 06 12:58 AM
Rounding to the nearest quarter (decimal) in a Pivot table	Fred	Excel Discussion (Misc queries)	3	April 3rd 06 03:26 PM
Format Round to Nearest Thousand	GillianHG	Excel Discussion (Misc queries)	3	March 21st 06 06:43 PM
How do I calculation time in excel in 24 hour method	Lloyd	Excel Discussion (Misc queries)	7	July 18th 05 08:43 AM

All times are GMT +1. The time now is 02:12 PM.

About Us

"It's about Microsoft Excel"