Thread: [Solved] IF Formulas
View Single Post
 
Old 07-08-2010, 02:32 AM
mugezhn mugezhn is offline Windows XP Office 2007
Novice
  
Join Date: Jul 2010
Posts: 16
mugezhn is on a distinguished road
Default
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)
Reply With Quote