![]() |
#2
|
|||
|
|||
![]()
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 |
|
![]() |
||||
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 |
![]() |
justziggy | Word | 5 | 05-23-2009 02:33 AM |