|
|
#1
08-19-2017, 01:18 AM
|
|||
|
|||
Program with Hours
Please see the attached picture. I have the first two steps, but need the third step to make the cell bring back 0.0 hours even if column C or E has an 'X' in it, when columns A & B are blank. The resulting formula has to do step 1 and 2 as well as 3. All help will be appreciated! 
|
|
#2
08-20-2017, 06:27 AM
|
|||
|
|||
|
In D1 this should also look after time that crosses midnight.
=IF(OR(A1="",B1=""),0,IF(OR(C1="x",E1="x"),(((B1-A1)+(B1<A1))*24)-0.5,((B1-A1)+(B1<A1))*24))
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Project Hours
|
Mav | Project | 4 | 03-07-2014 04:47 PM |
|
How to add hours together
|
PomDave | Excel | 3 | 09-05-2011 04:43 AM |
|
Not sure what program to use
|
komobu | Office | 1 | 02-25-2011 04:14 PM |
| Help on the formulate hours | meninio | Excel | 2 | 02-11-2011 04:56 AM |
|
Don't know which program to use!
|
Raner | Office | 3 | 12-09-2009 08:08 AM |
Windows 10 
Office 2016
Linear Mode
