Display Time

Yahoo Archive
1
Jasper,
I ran into this also and here's what I used:

NumberVar MinNum:= If Len(ToText({LaborHed.LunchOutTime})) = 4 Then
ToNumber (Mid(ToText
({LaborHed.LunchOutTime}),2,3)) Else
ToNumber (Mid(ToText
({LaborHed.LunchOutTime}),3,3));

StringVar Hr:= If Len(ToText({LaborHed.LunchOutTime})) = 4 Then
"0" + Mid(ToText({LaborHed.LunchOutTime}),1,1) Else
Mid(ToText({LaborHed.LunchOutTime}),1,2);

StringVar Min:= If MinNum = .00 Then "00" Else Mid(Totext(MinNum *
60),1,2);

If {LaborHed.LunchOutTime} = 0.00 Then "00:00"
Else
Hr + ":" + Min

I hope this helps.

Aceplayr


--- In vantage@yahoogroups.com, "Jasper Recto" <jrecto@...> wrote:
>
> Does anybody know how I can convert the Actual Clock In time that
is in hundredths to an actual readable time?
>
>
>
> Thanks,
> Jasper
>
>
>
> [Non-text portions of this message have been removed]
>
2
Does anybody know how I can convert the Actual Clock In time that is in hundredths to an actual readable time?



Thanks,
Jasper



[Non-text portions of this message have been removed]
3
If you are using the LaborHed or LaborDtl tables, there is a field
called "DspClockInTime" that might be what you want.

-Sarah

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Monday, July 31, 2006 9:54 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Display Time

Does anybody know how I can convert the Actual Clock In time that is in
hundredths to an actual readable time?



Thanks,
Jasper



[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/.
(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/links
Yahoo! Groups Links
4
That field is for the adjusted time. I need the actual time which does not have a built in display field.

Jasper

-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Monday, July 31, 2006 10:15 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Display Time



If you are using the LaborHed or LaborDtl tables, there is a field
called "DspClockInTime" that might be what you want.

-Sarah

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On Behalf
Of Jasper Recto
Sent: Monday, July 31, 2006 9:54 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Display Time

Does anybody know how I can convert the Actual Clock In time that is in
hundredths to an actual readable time?



Thanks,
Jasper


[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. <http://groups.yahoo.com/group/vantage/files/.> yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages> yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/links> yahoo.com/group/vantage/links
Yahoo! Groups Links







[Non-text portions of this message have been removed]
5
Jasper,

I don't know if there is an easier way but I wrote a function to do the
conversion in Access. I wasn't sure how Vantage deals with Midnight
(0:00 or 24:00) so I wrote in the word. I did the same for noon just to
be consistent. Our shifts change at 6am, 2pm, and 10pm so it hasn't
come up yet.



If anyone knows about how midnight is displayed, please let me know so I
can adjust.





Function ConvertTime(DecTime) As String

Dim hour As Integer

Dim min As Variant

Dim ampm As String





If DecTime < 0 Or DecTime > 24 Then

ConvertTime = "Error"

GoTo Exit_ConvertTime

End If



If IsNull(DecTime) Then

ConvertTime = ""

GoTo Exit_ConvertTime

End If

If DecTime = 0 Or DecTime = 24 Then

ConvertTime = "Midnight"

GoTo Exit_ConvertTime

End If



If DecTime = 12 Then

ConvertTime = "Noon"

GoTo Exit_ConvertTime

End If





hour = Int(DecTime)

If hour < 12 Then

ampm = "am"

Else

ampm = "pm"

End If





min = DecTime - hour

min = Round(min * 60)

If min < 10 Then min = "0" & min

If min = 0 Then min = "00"





If hour > 12 Then hour = hour - 12





ConvertTime = hour & ":" & min & ampm



Exit_ConvertTime:

'MsgBox ConvertTime



End Function



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Monday, July 31, 2006 9:54 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Display Time



Does anybody know how I can convert the Actual Clock In time that is in
hundredths to an actual readable time?



Thanks,
Jasper


[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
6
The formula in crystal and ms query and access is the same "DisplayTime:
(([systime] / 3600) / 24) "

There must be a way to apply this to Vantage forms.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jasper Recto
Sent: Monday, July 31, 2006 9:54 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Display Time



Does anybody know how I can convert the Actual Clock In time that is in
hundredths to an actual readable time?



Thanks,
Jasper


[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
7
Check the System Management/Configuration Maintenance/Company
Configuration/Module Configuration/Job Management Configuration. There is a
Time Format on the left hand side, the 2nd set of options; you have a choice
of Hours/Minutes or Hours/Hundredths.

Hope that helps!


Thanks,

Cindy House
GTech Precision
Corporate Controller
(w) 817-539-8014
(f) 817-539-8018
(c) 817-832-8933
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Jasper Recto
Sent: Monday, July 31, 2006 8:54 AM
To: Vantage Groups (E-mail)
Subject: [Vantage] Display Time



Does anybody know how I can convert the Actual Clock In time that is in
hundredths to an actual readable time?



Thanks,
Jasper


[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]