基于多个记录的时差 [英] Time difference based on multiple records

问题描述

嗨


我正在寻找可根据附加文件执行计算的公式或代码。

记录可以在ACCESS表中带有ID。

请帮助

Hi

I am looking for a formula or code which can perform a calculation as per the attched file.
The records can be in ACCESS table with an ID.
Please help

附加文件

time calculation.xlsx （9.1 KB，305 views）

Attached Files

time calculation.xlsx (9.1 KB, 305 views)

推荐答案

rajeevs，

我害怕你的问题没有任何意义。没有什么可回答的。你想要什么？什么计算？请花点时间清楚说明你想要的东西。请记住，大多数人都不打算下载你的附件。


Jim

rajeevs,
I''m afraid your "question" doesn''t make any sense. There''s nothing to answer. What do you want? What calculation? Please take the time to spell out clearly what you want. And remember that most people are not going to download your attachment.

Jim

rajeevs，


你的桌子到底想要做什么？你的表（在预期的列中）似乎没有任何意义，你想要它计算什么。


任何时候你在Excel或Access中计算日期和时间都很棘手。您的电子表格似乎直截了当，但不知道你想要做什么，很难提出建议。

rajeevs,

Exactly what is your table trying to do? Your table (in the expected column) does not seem to make any sense as to what you want it to calculate.

Any time you calculate dates and times can be tricky in Excel or Access. Your spreadsheet "seems" straightforward, but without knowing exactly what you want to do, it is difficult to proerly advise.

谢谢jim& twinnyfo

我有一个带有输入时间字段的记录集。记录将根据输入时间按排序顺序排列。我想知道如果任何记录的入口时间少于5分钟，那么我需要将该记录的输入时间更改为与前一记录和下一记录分开五分钟。希望我已正确解释了这个问题。请帮帮我

Thank you jim & twinnyfo
I have a recordset with an entry time field. the records will be in a sort order based on the entry time. I want to find out if any record has an entry time less than 5 minutes compared to the previous record then I need to change the entry time of that record to have a separation of five minutes with the previous record and next record. Hope I have explained the issue correctly. Please help me

这篇关于基于多个记录的时差的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！