说明:TIME 函数的功能,将特定的时、分、秒,转换成代表时间的数。
TIME 函数的语法结构。TIME(hour, minute, second),
参数说明:
hour 时
minute 分
second 秒
第一步,调用TIME函数,即输入“=TIME”,在输入过程中Excel会自动提示函数的功能;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2fdfc039245d6883bb5564aaac27d1ed31b24ad?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第二步,设定参数hour;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9f510fb30f2442a7d06f194bdf43ad4bd01302fe?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第三步,设定参数minute;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f9198618367adab4657fffad85d4b31c8601e4b5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第四步,设定参数second;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/a08b87d6277f9e2f3f56f9e61130e924b999f3f9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第五步,点击回车查看计算结果;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8718367adab44aed1e2c5a0abd1c8701a08bfbfa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第六步:将小数转换成时间格式,为了便于理解另起一个单元格;
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f7246b600c3387448060cb925f0fd9f9d62aa0b3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第七步:通过设定单元格格式,将小数转换成时间格式。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/aec379310a55b319f76c669b4da98226cefc1742?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
第八步:完成效果图。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/cb8065380cd791231c6a709aa3345982b3b78052?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)