Thank you for the formula it worked great. (I had to remove /60 part
because Vantage uses hours though)
-----Original Message-----
From: Doug Williams [SMTP:dwilliams@...]
Sent: Wednesday, January 10, 2001 2:07 PM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Adjusting time
I believe that the formula "ROUND(ClockInMInute / 60 * 4,0) / 4" should do
the trick for you. Remember that ClockInMinute is stored as minutes since
eMfg's "start of time." Dividing by 60 converts that into hours and
hundredths of hours. Performing the round after multiplying by 4 rounds to
the nearest quarter hour. Dividing by 4 converts it back to hours.
Hope that this helps,
Doug Williams
Vantage Development Manager
Epicor Software Corporation
-----Original Message-----
From: Shirley H. Graver [mailto:shirleyg@...]
Sent: Wednesday, January 10, 2001 12:51 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Adjusting time
I would think that you should be able to create a calculated field that
would take the hundreth minutes that would determine which of 4 catagories
they fall in. You could then convert the time to an interger then add back
the appropriate Hundreth of minutes IE: 0, 25, 50, 75. I would visualize
this formula in this manner:
IIF((StartTime - INTEGER(StartTime)) < .17,INTEGER(StartTime) ,
IIF((StartTime - INTEGER(StartTime)) > .17 And <= .37,INTEGER(StartTime)
+
.25),IIF((StartTime - INTEGER(StartTime)) > .37 And <=
67,INTEGER(StartTime) + .5,IIF((StartTime - INTEGER(StartTime)) > .67 And
<= .87,INTEGER(StartTime) + .75,INTEGER(StartTime))))
I havent tried this so the above formula is probably flawed. But this is
how I would start attacking the problem. You also want to be sure you use
the fields that are formated in hundreths of minutes.
Shirley Graver
(End User)
Sys Admin
Rubber associates Inc.
Cleveland/Akron
----Original Message-----
From: Oleg Tumarkin [mailto:otumarkin@...]
Sent: Wednesday, January 10, 2001 12:54 PM
To: 'vantage@egroups.com'
Subject: [Vantage] Adjusting time
I am looking at ways to round time to the nearest 15 minute intervals on
my
report builder report for in and out times, is there any way of doing
this?
If not is it possible to do it with Crystal Reports?
Regards,
Oleg Tumarkin
eGroups Sponsor
Click here to Win a 2001 Acura MDX
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
[Non-text portions of this message have been removed]
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link
above
will work the next time you try it.)
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link
above will work the next time you try it.)
because Vantage uses hours though)
-----Original Message-----
From: Doug Williams [SMTP:dwilliams@...]
Sent: Wednesday, January 10, 2001 2:07 PM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Adjusting time
I believe that the formula "ROUND(ClockInMInute / 60 * 4,0) / 4" should do
the trick for you. Remember that ClockInMinute is stored as minutes since
eMfg's "start of time." Dividing by 60 converts that into hours and
hundredths of hours. Performing the round after multiplying by 4 rounds to
the nearest quarter hour. Dividing by 4 converts it back to hours.
Hope that this helps,
Doug Williams
Vantage Development Manager
Epicor Software Corporation
-----Original Message-----
From: Shirley H. Graver [mailto:shirleyg@...]
Sent: Wednesday, January 10, 2001 12:51 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Adjusting time
I would think that you should be able to create a calculated field that
would take the hundreth minutes that would determine which of 4 catagories
they fall in. You could then convert the time to an interger then add back
the appropriate Hundreth of minutes IE: 0, 25, 50, 75. I would visualize
this formula in this manner:
IIF((StartTime - INTEGER(StartTime)) < .17,INTEGER(StartTime) ,
IIF((StartTime - INTEGER(StartTime)) > .17 And <= .37,INTEGER(StartTime)
+
.25),IIF((StartTime - INTEGER(StartTime)) > .37 And <=
67,INTEGER(StartTime) + .5,IIF((StartTime - INTEGER(StartTime)) > .67 And
<= .87,INTEGER(StartTime) + .75,INTEGER(StartTime))))
I havent tried this so the above formula is probably flawed. But this is
how I would start attacking the problem. You also want to be sure you use
the fields that are formated in hundreths of minutes.
Shirley Graver
(End User)
Sys Admin
Rubber associates Inc.
Cleveland/Akron
----Original Message-----
From: Oleg Tumarkin [mailto:otumarkin@...]
Sent: Wednesday, January 10, 2001 12:54 PM
To: 'vantage@egroups.com'
Subject: [Vantage] Adjusting time
I am looking at ways to round time to the nearest 15 minute intervals on
my
report builder report for in and out times, is there any way of doing
this?
If not is it possible to do it with Crystal Reports?
Regards,
Oleg Tumarkin
eGroups Sponsor
Click here to Win a 2001 Acura MDX
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
[Non-text portions of this message have been removed]
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link
above
will work the next time you try it.)
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link
above will work the next time you try it.)