By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,497 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

calculating time

P: 14
help me with this. TotalTime:DateDiff("n",[starttime],[endtime])im getting mins instead of hours & mins. example" instead of 1.5 hr im getting 90. i know its something very easy to fix, but cant find it in Acess for Dummies.
Dec 13 '11 #1

✓ answered by Rabbit

DateDiff returns an integer so you can't use it for fractionals. You have to go to a lower unit and then divide. Look at my post again. I told you how to get fractionals.

Share this Question
Share on Google+
6 Replies


Rabbit
Expert Mod 10K+
P: 12,316
I don't know why you would expect to get hours when you're asking the function to give you minutes. Divide the result by 60 and that will give you fractional hours.
Dec 13 '11 #2

P: 14
ok how do i ask the function to give me hours, thats the only formula i know to get start time and end time to work.
Dec 13 '11 #3

Expert 100+
P: 446
Try
TotalTime:DateDiff("h",[starttime],[endtime])
Dec 13 '11 #4

P: 14
i tried that sierra it just gave me a 0 for an answer
Dec 13 '11 #5

P: 14
examle my time start is 11:00 and end time is 15.:15 im getting the answer 6 even thought we know that it should be 6hr15ms
Dec 13 '11 #6

Rabbit
Expert Mod 10K+
P: 12,316
DateDiff returns an integer so you can't use it for fractionals. You have to go to a lower unit and then divide. Look at my post again. I told you how to get fractionals.
Dec 13 '11 #7

Post your reply

Sign in to post your reply or Sign up for a free account.