基于几个标准来计算小时数的有挑战性的公式 [英] Challenging formula to calculate amount of hours based on several criteria

问题描述

我正在从事商务旅行模板，我正在尝试纳入我们的一些政策，如下（额外的小时标准如下）：

I am working on a business travel template where I am trying to incorporate some of our policies as follows (additional hours criteria below):

在单元格N15中，我需要基于场景下图像上列出的条件来添加总计的小时数。我只需要找一个公式来计算出额外的小时数。 （交通工具选择是一个下拉菜单，这个例子中列出了所有可用的选项。）

In cell N15, I need the total number of hours to be added based on the criteria listed on the image below the scenario. I just need to find a formula to work out the number of additional hours. (Means of transport selection is a drop down, all available options are listed in this example.)

推荐答案

希望可以通过以下方式实现：

I think the result you want might be achieved with:

=3*COUNTIF(K:K,"L*Outbound")+2*(COUNTIF(K:K,"S*Outbound")+COUNTIF(K:K,"L*Inbound"))+COUNTIF(K:K,"S*Inbound")+0.5*COUNTIF(K:K,"T*")  

您的示例返回 9 。

这篇关于基于几个标准来计算小时数的有挑战性的公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！