救命！！时间计算。 [英] Help!! Time Calculations.
问题描述
大家好，
我正在创建一个TimeSheet数据库，我需要计算员工工作多少小时
。问题是当他们进入时间，它
没有计算分钟数，它只是计算小时数。它最多为
6而不是5:30。
我正在使用这个公式：
Me.Hours =（DateDiff（" h"，Me.Start，Me.Stop））
Ex：
开始停止时间
08:30 AM 02:00 PM 6<应该是5个半小时
我如果有人可以帮助我，我将不胜感激。
先谢谢。
Hi all,
I''m creating a TimeSheet Database, I need to calculate how many hours
the Employee works.The problem is that when they enter the time, it
doesn''t calculate the minutes, it just calculate hours.it rounds up to
6 and not 5:30.
I''m using this formula:
Me.Hours = (DateDiff("h", Me.Start, Me.Stop))
Ex:
Start Stop Hours
08:30AM 02:00PM 6 <it should be 5 hours and half
I would be grateful, if someone can help me.
Thanks in advanced.
推荐答案
cs ******** @ partners.org （christian）写在
news ：e1 ************************** @ posting.google.c om：
cs********@partners.org (christian) wrote in
news:e1**************************@posting.google.c om:
我。小时=（DateDiff（" h"，Me.Start，Me.Stop））
Ex：
Start Stop小时
08:30 AM 02:00 PM 6<它应该是5个半小时
Me.Hours = (DateDiff("h", Me.Start, Me.Stop))
Ex:
Start Stop Hours
08:30AM 02:00PM 6 <it should be 5 hours and half
DateDiff以整数形式返回间隔数（in这种情况
间隔是小时）越过边界。也许你可以指定分钟和
除以60.
-
Lyle
（有关电子邮件，请参阅 http://ffdba.com/contacts.htm ）
尝试使用分钟（n）参数，然后将结果除以
60，得到小时后的小时数。
Mike Storr
www.veraccess.com
" christian" < CS ******** @ partners.org>在消息中写道
news：e1 ************************** @ posting.google.c om ...
Try using the minutes ("n") argument instead and then divide the result by
60 to get hours as a decimal.
Mike Storr
www.veraccess.com
"christian" <cs********@partners.org> wrote in message
news:e1**************************@posting.google.c om...
大家好，我正在创建一个TimeSheet数据库，我需要计算员工工作多少小时。问题是当他们进入时间时，它
没有计算分钟数，它只是计算小时数。它会累计到6而不是5:30。
我正在使用这个公式：
Me.Hours =（DateDiff（" h"，Me.Start，Me.Stop））
Ex：
Start Stop Hours
08:30 AM 02:00 PM 6<应该是5个半小时
如果有人可以帮助我，我将不胜感激。
先谢谢。
Hi all,
I''m creating a TimeSheet Database, I need to calculate how many hours
the Employee works.The problem is that when they enter the time, it
doesn''t calculate the minutes, it just calculate hours.it rounds up to
6 and not 5:30.
I''m using this formula:
Me.Hours = (DateDiff("h", Me.Start, Me.Stop))
Ex:
Start Stop Hours
08:30AM 02:00PM 6 <it should be 5 hours and half
I would be grateful, if someone can help me.
Thanks in advanced.
非常感谢。
你可以帮我配方，因为我不是真的知道在哪里
除以60.
再次感谢
***通过Developersdex发送 http://www.developersdex.com ***
不要只参加USENET ......获得奖励！
Thank you very much.
Could you help me with the formula, because I don''t really know where to
divide by 60.
Thanks once again
*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!
这篇关于救命！！时间计算。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
