This is really helpful. thanks.
Can you help me with the formula for the ClockInMinute?
I am looking to get the actual hours when a lobordtl indirect code is IDLE. it always starts from 12:00:00am. we need acutal hours.
i am trying to find out if the LaborDtl.ClockinMinute will show that info.
Can you help me with the formula for the ClockInMinute?
I am looking to get the actual hours when a lobordtl indirect code is IDLE. it always starts from 12:00:00am. we need acutal hours.
i am trying to find out if the LaborDtl.ClockinMinute will show that info.
--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> A cheesier but just as effective method would be this...
>
>
>
> Time((.0416667*{BAQReportResult.LaborHed.ClockInTime}))
>
>
>
> Format your field for short time
>
>
>
> That is a constant I worked out that is pretty accurate.
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: (715) 284-5376 ext 3111
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Ross Hughes
> Sent: Thursday, September 24, 2009 10:21 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Time Formula
>
>
>
>
>
> If you mean in Crystal, you can try this:
>
> // Convert the decimal into elements
> NUMBERVAR HourSplit := TRUNCATE({BAQReportResult.LaborHed.ClockInTime});
> NUMBERVAR MinuteSplit := (60 * ({BAQReportResult.LaborHed.ClockInTime} -
> HourSplit));
> NUMBERVAR Minutes := TRUNCATE(MinuteSplit);
>
> // Insert elements in to TIME function
> If Hoursplit <> 24 Then
> TIME (HourSplit, Minutes, 0)
> Else
> TIME(0,Minutes,0)
>
> Ross
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Jonathan Lang
> Sent: Thursday, September 24, 2009 9:50 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Time Formula
>
> Does any one have a good Time formula. I am trying to convert decimal to
> time.
>
> Thank you,
> Jonathan Lang
> Oil Rite Corporation
> Sr. Network Administrator
> Ph: (920) 682-6173 Ext: 126
> Fax: (920) 682-7699
>
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>
>
> [Non-text portions of this message have been removed]
>