Time Calculation

[Guest]

I am trying to calculate time using Allen Browne's theory. I ran a query
puting Minutes: DateDiff("n", [StartDateTime],[EndDateTime]) and then I
displayed the hours and minutes in the form with a text box with this in the
Control Source: =[Minutes]\60 and Format ([Minutes]Mod 60, "\:00"). Our
documenting system is on tenths. For every six minutes that is a tenth.
How I would like for it to calculate is in tenths, how would I force it to
reflect tenths. Thanks..Melinda

 

[Bewilly]

Melinda
depending on your rules for when the next tenth is met i believe there are 2
options:
if 12:05 is not a tenth but 12:06 is then it will simply be:
INT([Minutes]/6) would give you the number of tenths (also assuming minutes
doesn't get greater than 60.
If 12:04 to 12:09 is 1 tenth then:
Tenths = INT([minutes]/6) + ROUND(([minutes] MOD 6) / 6 , 0)

 

[Guest]

Excuse my stupidity, but would I enter this into the query or the form?

Melinda
depending on your rules for when the next tenth is met i believe there are 2
options:
if 12:05 is not a tenth but 12:06 is then it will simply be:
INT([Minutes]/6) would give you the number of tenths (also assuming minutes
doesn't get greater than 60.
If 12:04 to 12:09 is 1 tenth then:
Tenths = INT([minutes]/6) + ROUND(([minutes] MOD 6) / 6 , 0)

I am trying to calculate time using Allen Browne's theory. I ran a query
puting Minutes: DateDiff("n", [StartDateTime],[EndDateTime]) and then I
displayed the hours and minutes in the form with a text box with this in the
Control Source: =[Minutes]\60 and Format ([Minutes]Mod 60, "\:00"). Our
documenting system is on tenths. For every six minutes that is a tenth.
How I would like for it to calculate is in tenths, how would I force it to
reflect tenths. Thanks..Melinda

 

[Guest]

excuse my stupidity, but would I add this into the query or the form?

Melinda
depending on your rules for when the next tenth is met i believe there are 2
options:
if 12:05 is not a tenth but 12:06 is then it will simply be:
INT([Minutes]/6) would give you the number of tenths (also assuming minutes
doesn't get greater than 60.
If 12:04 to 12:09 is 1 tenth then:
Tenths = INT([minutes]/6) + ROUND(([minutes] MOD 6) / 6 , 0)

I am trying to calculate time using Allen Browne's theory. I ran a query
puting Minutes: DateDiff("n", [StartDateTime],[EndDateTime]) and then I
displayed the hours and minutes in the form with a text box with this in the
Control Source: =[Minutes]\60 and Format ([Minutes]Mod 60, "\:00"). Our
documenting system is on tenths. For every six minutes that is a tenth.
How I would like for it to calculate is in tenths, how would I force it to
reflect tenths. Thanks..Melinda

 

[Bewilly]

You can put it in either spot.
It may get a little tricky in the query. Not knowing what your data looks
like you would probably have to substitute your datediff function where i
have [Minutes] notated. It may be easier just to put the tenths onto the form
using the formula i have and reference the textbox that has minutes in it.

excuse my stupidity, but would I add this into the query or the form?

Melinda
depending on your rules for when the next tenth is met i believe there are 2

[quoted text clipped - 12 lines]

 

[Melinda]

Sorry, but I am finally getting back to the clock, had a few interuptions
along the way. I added a text box and put =([Minutes]/6) in the control
source of the text box that I added. When I do a calculation that has 503
minutes I then get 838.33333 in that text box that but it doesn't change the
minutes in the Hours/Minutes box. What am I doing wrong?

You can put it in either spot.
It may get a little tricky in the query. Not knowing what your data looks
like you would probably have to substitute your datediff function where i
have [Minutes] notated. It may be easier just to put the tenths onto the form
using the formula i have and reference the textbox that has minutes in it.

excuse my stupidity, but would I add this into the query or the form?

Melinda
depending on your rules for when the next tenth is met i believe there are 2

[quoted text clipped - 12 lines]

How I would like for it to calculate is in tenths, how would I force it to
reflect tenths. Thanks..Melinda