Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the rocket domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/practical-tips.com/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the soledad domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/practical-tips.com/wp-includes/functions.php on line 6114

Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the soledad domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /var/www/practical-tips.com/wp-includes/functions.php on line 6114
Excel:如何减去时钟时间 - Practical Tips

Excel:如何减去时钟时间

by Mike

在 Excel 中使用简单的公式减去时间。有些结果需要在之后进行格式化才能正确显示

Excel:如何减去时间

在 Excel 中,您可以做的不仅仅是添加时间。由于程序会自动识别,因此只需一个公式即可完成操作。

  • 时间 1 单元格-时间 2 单元格 在相应的单元格中输入您要减去的 09:00 格式的时间,例如 =D3-D4,然后用 [ENTER] 键确认。
  • 您可以自行决定在哪个单元格中书写公式。Excel 会减去这些值,并以小时和分钟为单位显示差值。
  • 例如,如果 D3 单元格中的时间是 08:20,而 D4 单元格中的时间是 10:00,Excel 将计算出结果为 01:40。如果单元格中的值发生变化,结果会自动更新。
  • 重要:如果相差超过 24 小时,请右键单击结果单元格。在 “格式单元格 “下,您可以找到 “用户定义 “下的 [hh]:mm 格式。选择该格式:

Related Articles

Leave a Comment