IF Formulas

		Microsoft Office Forums > Microsoft Excel > Excel
IF Formulas

FAQ

Thread Tools

Display Modes

07-08-2010, 02:32 AM

mugezhn

Windows XP IF Formulas

Office 2007

Novice

Join Date: Jul 2010

Posts: 16

Try this

Write 08:00 in Cell D and 20:00 in Cell E.

Apply the following formula in Cell C:

=IF(A2<D2;(D2-A2)*0,5;0)+IF(B2>E2;(B2-E2)*0,5;0)

(Assuming that you use Row 2)

Tags

formulas

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't calculate formulas	Cpat	Excel	2	06-09-2010 02:07 PM
Simple formulas	den hobbelder	Word	1	02-26-2010 01:53 PM
Table formulas	markg2	Word Tables	0	01-15-2010 06:49 AM
Creating Formulas in a Word Form	pittz2002	Word	0	08-25-2009 08:36 AM
How to transfer multiple cells from excel to word by formulas	justziggy	Word	5	05-23-2009 02:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:18 PM.