kremlin1313
New Member
- Joined
- May 8, 2015
- Messages
- 4
A | B | C | D | E | ||||
1 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | Duration | Amount | |||
2 | A |
<tbody> </tbody> |
<tbody> </tbody> | |||||
3 | B | |||||||
4 | C |
<tbody>
</tbody>
I need to display in column D the elapsed time between B and C columns in hh:mm. and the corresponding rates in column E.
Conditions:
IF D2 = 1, D2*15
IF D2 > 1, multiply the number of hours to 15(the rate per hour) plus the rates if below 1 hour
example if DURATION is 1 hour and 25 minutes, its should be $15+10= $25
If D2:
< 20 minutes, $5
> 20 minutes but < 40 minutes, $10
> 40 minutes but < 1 hour, $15