朱士斌 发表于 2021-4-17 16:15:49

小时差怎么自动计算，表达式应该怎么写？

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAvAAAABKCAYAAADdaGBAAAASlElEQVR4Ae2djY3tuA2Fp4NXTHpKT+kpxWwHExDBwZ7HlWzZlofSfd8CBsVfybo8FK2dbL7++uuv76Pn6+vrUH/ki+54b+/uT/wm39887MHzHADf1zAK9p7nHLj9fQ/B4DUM3j035QeGf88/8DhnPypw/KWk7tGKRfXWgvz/hY4CNAdwFK6vb/B9rXkAe2Bvdt0Ag9cw+LQPAMNgeDaGI14FjmngT/4NxNNi8YY/BYgCNKsAVRSdNzDxUzHBHtibhT3FAYM08MoF6L71pQLHNPA08Pw5zh/850gVReenmu035qGB3/eAXbU5AoM08KvmJusar3cVOKaBp4GngaeB53/nMlgHaODHDzQO/7G9qjj43/i43SUmGB7LS/B7bZ8qcEwDP3hwr1ScKEDXgEUh6u9XRdFZCUtX1wL2+rkEzu7tDRjkBh7s3MPOSvtWgWMaeBp4buC5gecGfrAO0MDvf9CudOjHWioO/qsfrp9kD4bB8Bs1oALHNPCDB/dKBYwCRAGaVYAqis5KWLq6FrAH9mZhT3HAIDfwygXovvWlAsc08DTw3MBzA88N/GAdoIHf94BdtTmqOPivfrh+kj0YBsNv1IIKHNPADx7cKxUwChAFaFYBqig6K2Hp6lrAHtibhT3FAYPcwCsXoPvWlwocDzXwsTAe9oAcIAfIAXKAHCAHyAFygBz4Zw5cvRB6aj/UwD+dBP+5NwwBHL7U2YMZORC5BD7H8Qn2wN0M3HkMMDiOvxm1CgyDYcffrHEFjmng+RMaPgb4G3ia+ME6wOHP4T/rwFecioN/RiO8awwwDIaFvZm0Asc08IMH90rFigJEAZpVeCqKzkpYuroWsAf2ZmFPccAgN/DKBei+9aUCxzTwNPDcwHMDzw38YB2ggd/3gF21Oao4+K9+uH6SPRgGw2/Uggoc08APHtwrFTAKEAVoVgGqKDorYenqWsAe2JuFPcUBg9zAKxeg+9aXChzTwNPAcwPPDTw38IN1gAZ+3wN21eao4uC/+uH6SfZgGAy/UQsqcEwDP3hwr1TAKEAUoFkFqKLorISlq2sBe2BvFvYUBwxyA69cgO5bXypwTANPA88NPDfw3MAP1gEa+H0P2FWbo4qD/+qH6yfZg2Ew/EYtqMAxDfzgwb1SAaMAUYBmFaCKorMSlq6uBeyBvVnYUxwwyA28cgG6b32pwDENPA08N/DcwHMDP1gHaOD3PWBXbY4qDv6rH66fZA+GwfAbtaACxzTwgwf3SgWMAkQBmlWAKorOSli6uhawB/ZmYU9xwCA38MoF6L71pQLHNPA08NzAcwPPDfxgHaCB3/eAXbU5qjj4r364fpI9GAbDb9SCChzTwA8e3CsVMAoQBWhWAaooOith6epawB7Ym4U9xQGD3MArF6D71pcKHNPA08BzA88NPDfwg3WABn7fA3bV5qji4L/64fpJ9mAYDL9RCypwTAM/eHCvVMAoQBSgWQWoouishKWrawF7YG8W9hQHDHIDr1yA7ltfKnBMA08Dzw08N/DcwA/WARr4fQ/YVZujioP/6ofrJ9mDYTD8Ri2owDEN/ODBvVIBowBRgGYVoIqisxKWrq4F7IG9WdhTHDDIDbxyAbpvfanAMQ08DTw38NzAcwM/WAdo4Pc9YFdtjioO/qsfrp9kD4bB8Bu1oALHNPCDB/dKBYwCRAGaVYAqis5KWLq6FrAH9mZhT3HAIDfwygXovvWlAsc08DTw3MBzA88N/GAdoIHf94BdtTmqOPivfrh+kj0YBsNv1IIKHNPADx7cKxUwChAFaFYBqig6K2Hp6lrAHtibhT3FAYPcwCsXoPvWlwoclzbw+YUzP3K43vGJuNnP+Rj3npE1vW0TawPo7MGMHPC8P8rbbJf57Bv6syf79Pg8l/NHc/TiPZHHfDP2nRjso3LA8/lJbsp3JN6IjeI5ves3EiPHzrzHeDKOuNp7KHsxKwfeytejXN+igY+N8SdeyHmN9aLiRSV3GjrnY9ySuc2Z3m3fHMc6ZiUdcf7svRzN6WwXvD+e79nWdXnsMXp+LXlL5rHP9G57ZRxxwQx7MDMHPFdjPPpE3o7a+hzyU963YkjnNMdwncY5luROcxzxPeq+M8Yxz8zfj1jsZ+SA8ndGjo7G2KaB1wv5JmksemQjnWj2kfyI3vE5indXF+v4lKIR76LH30my0Xft2ffkPpfGbqtx6DR2Kp/dabzTWR5mmyNeuqBHj+aUffA+lv5I7jZ53IuV7a7yEXfWbx6x9HhMyfJcPXn4ZluPl8dHca7E6sXpyfM6nG+tf1acu++k+eUvXtTX/2Qc8c7ysGfTk+d42S7zbt/StWThk+XO+/gs/lks9386jnU9+b3wZf9aOdDL96f5euRf0sDHi+YnFpll2hDRno37yUYvLV+38fEVO8WSTxWNdbQSaDdZfg/xonqfzEsumvXiRXt2kotm+zO59DvTeOezPJaNaNjHWE/L322z3nWtseJmqjjyyXrxWp/sZ9KYY8bvneOIF9Uc4kWzPPjQZb3sMs12LT7LcgzN6XL5iEqXecmdhk22c97H7pfHrThh05Nnf9meyUfX04rTkkW8sxwdsTmLEXrthVP3a83TkvV83FbjoK2nt56en8/5ZBzxW78DMvblSQ4ob5/k5lXfkgZei/QX9nHonddYNOszf2TXmtv93TfbZl3wWSafN2nM+STRVvHN7yFeVOu8y9/107yiOY7kn0Dj3Y5yNfSy0Vi8/CQXH1SyHpWtx/Kx9IrV4lv2konKL/gsk+4KjRgzfvccR7yo5hAvmuU9XvJMj+JIJ5p9nc824kVlm3nJM812mT+zl77nNyrv2Sl+0BEbtz8bR7yjHDzTh2/Y9J4c2+P1xvLpxWzJtQ731dipzym54jnfGrusFUf6Ixp+Z78Jevboag7czcejXD3TLdPAx0J9A1rjLAveH72sy9xH+jyX8y17yUQVJ/gsk+5NGnNeTa4V7fN7OB9jPVfW7jHcryfPNprT7V3mcvfddRzvc5arshF1+5Ys9D151oWdPx5b4xxLvKjsPHbWBZ9l7jc6jhizf2uP6eOYJ/OjsvDLT8vX42ssKvtWnNDpcfvsI5szehQj645i9Wx78hwr7Pxp6bPsKR/z9fJPa/Hc7tmOyn2+3ng0luwUR+sVld6pbCUTn31cLlvRbCv5CA3fp78Z/uxhzgHl60gOzrIpaeAFPqfxQr4BZ2PXX/XN9s77mnzsNjGufGJdOXl25PN7iBfVO2Ve8kx7dj159s98z68nz/478PEuZ7ksG1HZZ17yoKE7emTrMUbGii3amkM6zTGTxnwzf9cc7yqvtWQ/yTPNduJFw97H2T/z2faMz/7iz/yyXn6Z9ux68uyf+eyX+Wx/h4+YrRyVXHRWXud4wbceramlyzK3fTqO2P6u4hX3KY14d34nfNi3oxyYnacjeV7WwPvi9OKioTsbhz4/itnz9bhucyQ/02nOn6Sx9qNE2kWX30O8qN4j85I77dn05O7bG/d8e/JenJXl8S5nuSsbpxo7PnIct8k68W7jY487Kj/y0XxPaaxl1u/ZipVlzvs4r+FI57bZzvkY++N+rbH7Sp9lmZddptnujM/+4rPfmVz6Hs3xMt/zuyKPmDkvXeZjz3GNQz/yyF5zHcWVTfZxucYepzf2OG7TipFlLXvZ3KER78rvgy37NZIDs/N0JLeXbODzRjjv43jBzGdZ1osX1SaJF5Xc42Vd8Fnmfm+NY86RhFrdJr+HeFGtP/OSi/b0Pbn8Ms324kVln3nJd6TxLmd5KhtR2QefZVknm0zdrjUOmWKLZrssP/Np2SvmKI0YM37nXpwsFy/am/tML79sl/mwa8nkL9qzyfLMyz/TbHfGZ3/x2e9MLr1o9j/j5feExhzKvxg77zktm1FZjiN/yUWzXLxotpNc1PW9cdhKJypZ8P7kuG7vupZc+iMafk9+L3zZv1YO3M3Ho1w90y3VwMdiW5sQMj2yEZ9pS9/ahPBzufgcT7ziZh/5ufztcczZSqAdZdrf/E49ebzjka38ZCde1Pcox8k+2bYVw212HMc7neWrbJxqLF/nNRaVTdAsC94ft9W45aNY7quxdPIXn+O4fnQcMWb8zlqrU8U9k0l/ZC9di8o/6JG+pZPMY2jc0kl2ROWf19OTR6xsK5l8fD7Jej5uexRHumz/lI91HeXfmV6+2S7zsgva0rVkPdterIjhj9tpnOdx3sdHc2sOxbxCw/fpb4Y/e5hzIOfulZy8a1vWwAuAovEC2gBRvVTmJXefnqznm+WZ93gaj9jI9k0a68jJA8+e3MmBkZw+sgndiL5n574+dvxkeebdVuMRG9leoRH3zj7jw771cuAsV8/0kb8tG5e1xi7rxZA8bI8eYchj+lh6xXNesmwvXjT73OUjXu+3QM7e3M2B2Xk6kt9lDbwvLl48v7zLsi77On82VtwcM/Mep+fjNj85jvXcTTL82DvPgaO8V067jWPB5bIN6jYuP9ON2vbmvRo/zzfCx9y+f4zZj6c5cJTPyulebgprZ3rNISp78UdxZCOfTM/0stccbi+Z28TYbVq87O/QiP30N8OfPcw5kHP2Tm5e9Slp4K8uEvvf/6s3FCCKRy4ed/mKorMznsEe2LuLtZ4fGPz9fHu7PoBhMNzD4hN5BY5p4Iv/k5B3ihUFiAL0pNC4b0XRuZPzq/iAPbDn+JkxBoM08DPyiBi1takCxzTwNPD860T7P6X504pgRdFZpRm/sw4a+NpD8hPxCQZp4D8xr/+0d6rAMQ08DTwNPA384X8F406j+6k+NPA08LMbk4qD/1PxOfJeYBgMz8ZwxKvAMQ08DTwNPA08DfxgHeDw5/CfffhXHPwjje6n2oBhMDwbwzTwgwfopxaVK+9FAaIAzSpANA/X/vU92AN7s7CnOGDwGgavnJUtWzAMhoW9mbQCx9zAb/jhQAGiAM0qPBVFp3Wo7iIDe2BvFvYUBwzSwCsXoPvWlwoc08DTwPMnNPwJDX9CM1gHaOD3PWBXbY4qDv5dPpjfWCcYBsNv1IIKHNPADx7cbxSSuzEpQBSgWQWooujczfsV/MAe2JuFPcUBg9zAKxeg+9aXChzTwNPAcwPPDTw38IN1gAZ+3wN21eao4uBf4WO4ag1gGAy/UQsqcEwDP3hwVxWb1rwUIArQrAJUUXRaOb2LDOyBvVnYUxwwyA28cgG6b32pwDENPA08N/DcwHMDP1gHaOD3PWBXbY4qDv5dPpjfWCcYBsNv1IIKHNPADx7cbxSSuzEpQBSgWQWooujczfsV/MAe2JuFPcUBg9zAKxeg+9aXChzTwNPAcwPPDTw38IN1gAZ+3wN21eao4uBf4WO4ag1gGAy/UQsqcEwDP3hwVxWb1rwUIArQrAJUUXRaOb2LDOyBvVnYUxwwyA28cgG6b32pwDENPA08N/DcwHMDP1gHaOD3PWBXbY4qDv5dPpjfWCcYBsNv1IIKHNPADx7cbxSSuzEpQBSgWQWooujczfsV/MAe2JuFPcUBg9zAKxeg+9aXChzTwNPAcwPPDTw38IN1gAZ+3wN21eao4uBf4WO4ag1gGAy/UQsqcEwDP3hwVxWb1rwUIArQrAJUUXRaOb2LDOyBvVnYUxwwyA28cgG6b32pwDENPA08N/DcwHMDP1gHaOD3PWBXbY4qDv5dPpjfWCcYBsNv1IIKHNPADx7cbxSSOzF//fr1Hf98ffGwB89zIHIpcopnbA/A3vOcA7e/7yEYHMPerBoFhn/PP/A4az++fvwibKiBjy8LnjX2IIoP/7AD7AA7wA6wA+wAO8AOrLED3MBvdht+5wb9qY9u4P/9r+9vHvaAHCAHyAFygBwgB8iB2hyggaeBP/1XMN7A/+e/X9887AE5QA6QA+QAOUAOkAM1ORAfTzTwNPA08HyU8FFGDpAD5AA5QA6QA5vkAA08zftp8x5/fjNyAx9fgkdf4q6Pce9RjJ4+y2UfNHTis5146WXvPpK5zd2x5huhd+fA7+/fm71gL8gBcoAcIAf+lByggaeBv93AjzS+PZssF+Bc7mPpM802zvtYfi7TOGgeSyZ5+LvMx9I51XxXZO7DmEOIHCAHyAFygBwgB3o5QANPA/+jDbwS0RtjyYK63Mdu42PZtGjIWo/85aN53dZlshd1vyw70sk2aMvO9Ywp2uQAOUAOkAPkADnQywEaeBr4H2vgvWmNce9Rsrq9ZJnKpkUlcx/JREPnY/FZ5vLQ+SOd0xjr6cWSHvr3XrEX7AU5QA6QA+QAOXCeAzTwNPCPGnhvZHtjB6KaWVHX5fFVG58/Yjnv4yOd2/XGWqf0ipep9CNUMaHnRYs9Yo/IAXKAHCAH/vQcqGrg/wf56dsoQ1oDdQAAAABJRU5ErkJggg==我想用修复时间减掉故障时间，月日时相减得到小时数。

GJZZH 发表于 2021-4-17 16:40:22

计算小时差可以用日期与时间函数的HourOfTheYear<时间戳>。示例:HourOfTheYear(时间戳("2020/3/26 16:55:23")) ，用途:返回从指定日期时间值中 那一年第一天0点到指定日期的那个小时已经度过的小时数, 返回值类型: 数值
表达式可以这样写   HourOfTheYear<本表单.修复时间>- HourOfTheYear<本表单.故障时间>

朱士斌 发表于 2021-4-17 17:45:57

返回的是整数，怎么可以做成3.5小时，变成小数呢？例如3小时40分，计算后是3.67小时呢？？

朱士斌 发表于 2021-4-17 17:47:26

返回的是整数，怎么可以做成3.5小时，变成小数呢？例如3小时40分，计算后是3.67小时呢？？

Prex 发表于 2021-4-19 08:41:56

试试这个计算公式：

页: [1]
查看完整版本: 小时差怎么自动计算，表达式应该怎么写？