Conditional formula

[vinofino]

I need to write a formula that will evaluate multiple OR's with numbers in a rime format with the two to the left of th ecolon open. I came up with this to start off which of course does not work.

=IF(E14>=xx:07 (OR(E14>=xx:22)),(OR(E14>=xx:37)),(OR(E14>=xx:52)))

objective is to round up to the next quarter hour if true and down if false.

Solution?

 

[dcardno]

Try:
=MROUND((D8 - INT(D8)) * 24,0.25) / 24

With the actual time in Cell D8 this will return the closest quarter-hour.

If yoiu want to retain any date values, try
=MROUND(D9, 0.25/24)

which is probably even easier, unless you are trying to discard dates - say to add times like on a timesheet

 

[T. Valko]

I need to write a formula that will evaluate multiple OR's with numbers in a rime format with the two to the left of th ecolon open. I came up with this to start off which of course does not work.

=IF(E14>=xx:07 (OR(E14>=xx:22)),(OR(E14>=xx:37)),(OR(E14>=xx:52)))

objective is to round up to the next quarter hour if true and down if false.

Solution?

Try this...

Book1
	A	B
1	Time	Rounded
2	2:05 PM	2:00 PM
3	12:27 AM	12:30 AM
4	6:15 PM	6:15 PM
5	2:25 AM	2:30 AM
6	1:20 AM	1:15 AM
7	2:49 AM	2:45 AM
8	7:18 PM	7:15 PM
9	5:47 AM	5:45 AM
10	7:04 AM	7:00 AM
Sheet2

Formula entered in B2 and copied down:

=ROUND(A2*96,0)/96