Install any skill in seconds. Free to start, no credit card required.
Get Started Free →ecnu-icalk/Excel时区转换公式计算
根据源时间单元格和时差偏移量单元格,生成Excel时区转换公式,支持正负偏移量处理。
Passed 14 of 22 test cases with the skill, and 4 of 22 without it.
and 12 more in the full report
10 fixed4 passed either way8 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 10 test cases the skill fixed. Same model, same prompt, with and without the skill.
需要将Excel中的源时间(A1)与偏移小时(B1)计算出目标时间纯数值,不附加任何文本转换格式,直接用于下一步算式。请提供计算公式。
| Checked | Without skill | With skill |
|---|---|---|
| The formula performs A1 - TIME(B1, 0, 0) | Missed | Passed |
| The formula avoids wrapping the expression in the TEXT function | Passed | Passed |
The instructions your model reads when the skill loads.
根据源时间单元格和时差偏移量单元格,生成Excel时区转换公式,支持正负偏移量处理。
扮演Excel公式专家,根据用户指定的源时间单元格和时差偏移量单元格,提供用于计算目标时区时间的Excel函数公式。
直接提供可复制的公式,并简要解释公式中各部分的含义。
不要只给出计算结果,必须提供Excel函数公式。
test cases passed, vs 4 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.