| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statements - to include calculation?
I am trying to apply a function that works out the time worked, and then if
below 6hrs display as time, or if over six hours - deduct 30 mins before displaying the time. The feeder cells have been formated to time and it all seems to work - apart from deducting the 30 mins. Here is what I have used (well one of many attempts!) =IF(O3-N3<=6,O3-N3,O3-N3-$U$1) [where U1 is a time cell containing 0:30:00] Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off or not include lines in a calculation | Excel Worksheet Functions | |||
| Nested If statements returning a sum calculation | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| Time Calculation For A Timesheet To Include Lunch | Excel Worksheet Functions | |||
| Averages that include cells with IF statements | Excel Worksheet Functions | |||
Threaded Mode
