Excel时差，包括百分之一秒 [英] Excel time difference, including hundredth of a second

问题描述

我想使用excel在两个包含hh:mm:ss，00格式数字的单元格之间计算时差.简单的减法不起作用.有人可以帮助我吗?谢谢

i want to calculate time difference using excel, between two cells containing numbers in format hh:mm:ss,00. a simple subtraction doesn't work. Anyone can help me? thanks

推荐答案

如果两个单元格包含有效的时间值，则假设您要从较大的值中减去较小的值(Excel除非您使用1904日期系统，否则不喜欢使用负时间值.

If the two cells contain valid time values then a subtraction should work assuming you are subtracting the smaller value from the larger one (Excel doesn't like negative time values unless you use 1904 Date System).

您尝试了什么公式?您得到了什么结果，您期望什么结果?

What formula did you try? What result did you get, what result do you expect?

这篇关于Excel时差，包括百分之一秒的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！