carl

Posts: n/a

Round UP Time

I have a time stamp like this:

11:23:20 AM

I would like to find a funtion that rounds the time up to the next whole
minute:

11:24:00 AM

Is it possible ?

Thank you in advance.

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
Help - Information with time and date	PM	Excel Discussion (Misc queries)	4	January 6th 05 08:25 AM
Round Time	JoeMNY	Excel Worksheet Functions	1	November 18th 04 07:19 PM
Round Time	cpme	Excel Worksheet Functions	2	November 18th 04 07:09 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	4	November 18th 04 03:24 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 10:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us