![]() |
#1
|
|||
|
|||
![]()
I am trying to write a formula to input into cell R18, R19, etc.. to accomplish the following:
The function I have inserted (=IF(J18=12,M18-G18,IF(J18=13,M18-G18,2)) almost works but I am hitting a snag. Here is what I need to accomplish. Time is being entered as 100th's, not minutes. #1 - If the number "14" is input into cell "J18, J19 etc.." and cell M34 is greater than G34, then R34 should dispaly the number "2" (representing 2 hours). #2 - If the number "14" is input into cell "J18, J19 etc.." and cell M34 is equal or less than cell G34, then R34 should dispaly the number as a "0". #3 - If the number "12" or "13" is input into cell "J18, J19 etc.." then M34 should dislay the result of M34 minus G34. Any negative number should display as a Zero. "G""J""M""R"Layover StartDriver Hour ClassStart TimeLoad ReadyTime Paid19.021419.022.0019.021421.352.0019.021319.150.0219.021218.590.0019.021220.000.96 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Excelsior44 | Excel | 3 | 02-07-2017 05:46 PM |
Google "=Filter()" function excel equivalent. | Sadodare | Excel | 0 | 08-01-2016 11:15 AM |
"one click" function to switch between branded presentations | davidolone | PowerPoint | 0 | 01-16-2016 01:54 PM |
Error: "The function you are attempting to run contains macros" | Fadi | Word | 1 | 11-01-2011 05:25 AM |
![]() |
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |