如何总结时间超过24小时 [英] How to sum up the time more then 24 hours

问题描述

我总结了一个星期以上的工作时间，其中一些工作持续时间超过24小时
，当访问总结这些时，它似乎是
$ b一旦超过23:59，$ b将在00:00再次开始。


是否可以显示24小时内的小时和分钟时间

时钟？即34:23？

解决方案

假设您有两个字段： JobStart & JobEnd

您需要将数据类型设置为日期/时间

现在您必须按如下方式维护给定作业所花费的时间：

例如JobStart：11/08/2016 10:00和JobEnd：14/08/2016 15:30

现在创建一个查询并创建一个字段名称Diff：[JobEnd] - [JobStart]

现在创建另一个字段 TimeTaken ：[Diff] * 24（只需多个Diff。与24.）

你会得到你想要的数字。

对不起，不要认为这适用于英语日期（假设你的例子中的8表示8月


在调试窗口中，

展开 | 选择 | Wrap | 行号

Phil，I''我仍然想知道是否是这种情况！

虽然我还不太相信......！根据我的知识，日期只是从01.01.10000开始的天数（根据计算机的第1天）。所以从逻辑上讲，两个日期之间的差异应该给出相同的数字（无论是英国还是美国的日期制度）。但另一方面，如果你这样说，那对我来说就是一个学问。

谢谢&问候

I''m summing up time spent on jobs over a week, some of these jobs last
greater than 24 hours and when access sums these up it appears that it
starts again at 00:00 once it gets past 23:59.

Is it possible to display the time taken in hours and mins past the 24 hour
clock? i.e 34:23?

解决方案

Lets assume you have two fields : JobStart & JobEnd
You need to set data type as Date/Time
Now you have to maintain the time taken by a given job as follows :
e.g. JobStart : 11/08/2016 10:00 and JobEnd : 14/08/2016 15:30
Now create a query and create a field name Diff: [JobEnd]-[JobStart]
Now create another field TimeTaken : [Diff]*24 (simply multiple the Diff. with 24.)
You''ll get the numbers your want.

Sorry, Don''t think that will work for English dates (Assuming that the "8" in your example means August

In the debug window,

Expand|Select|Wrap|Line Numbers

Phil, I''m still wondering if this is the case!
Although I''m still not so convinced...! According to my knowledge, the dates are nothing but the number of days starting from 01.01.1900 (which is day 1 as per computer). So logically the difference between the two dates should give same number (whether it is UK or American date system).. But on the other hand, If you are saying so, it is a learning for me.
Thanks & regards

这篇关于如何总结时间超过24小时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！