473,549 Members | 2,876 Online

# calculating time

14 New Member
help me with this. TotalTime:DateD iff("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
6 1436
Rabbit
12,516 Recognized Expert Moderator MVP
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
jawbone
14 New Member
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
sierra7
446 Recognized Expert Contributor
Try
TotalTime:DateD iff("h",[starttime],[endtime])
Dec 13 '11 #4
jawbone
14 New Member
i tried that sierra it just gave me a 0 for an answer
Dec 13 '11 #5
jawbone
14 New Member
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
12,516 Recognized Expert Moderator MVP
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