carl

Posts: n/a

Round Up Time IF

Hi. I have another roundup question dealing with time.

Can a roundup formula do the following:

If my time is past the 30 second threshhold, round up to the next whole
minute plas 1 minute. If the time os not past the 30 second threshold, round
up to the nearest minute. For example:

1:23:33 PM rounds up to 1:25:00 PM
1.23:15 PM rounds up to 1:24:00 PM

Thank you in advance again.

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
Round UP Time	carl	Excel Worksheet Functions	1	January 7th 05 04:31 PM
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 05:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us