Actual Clock-In Times

Thanks! I think I came up wth a solution. Just grabbed the whole
number off the ActualClockInTime and then took 60 * the decimal
part, put both parts in string format and combined the whole thing
to make 6.50 look like 6:30.

- Erik

--- In vantage@yahoogroups.com, "Shirley Graver" <shirleyg@...>
wrote:
>
> Eric,
> There are some clock in reports in the files section
of the
> yahoogroup. You might download those and save some coding time.
> Shirley Graver
> Rubber Associates.
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> rfc822 Compliance issue From: added by system POTENTIAL SPAM
> Sent: Friday, April 28, 2006 10:00 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Actual Clock-In Times
>
> I am trying to put together a report (Report Builder) that shows
> employee actual clock-in times for the day. The field,
> LaborHed.ActualClockInTime holds this information but it is in
decimal
> format. Is there a field that shows this information in a HH:MM
> format? If not, how do I convert it?
>
> Thanks!
>
> - Erik
>
>
>
>
>
>
> 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/links
>
>
>
> SPONSORED LINKS
>
> Manufacturing
> <http://groups.yahoo.com/gads?
t=ms&k=Manufacturing+software&w1=Manufacturing
>
+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=P
>
da+database+software&w5=Database+management+software&w6=Database+mark
eting+s
> oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
> Membership
> <http://groups.yahoo.com/gads?
t=ms&k=Membership+database+software&w1=Manufac
>
turing+software&w2=Membership+database+software&w3=Database+mortgage+
softwar
>
e&w4=Pda+database+software&w5=Database+management+software&w6=Databas
e+marke
> ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database
software
> Database
> <http://groups.yahoo.com/gads?
t=ms&k=Database+mortgage+software&w1=Manufactu
>
ring+software&w2=Membership+database+software&w3=Database+mortgage+so
ftware&
>
w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketi
> ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage
software
>
> Pda
> <http://groups.yahoo.com/gads?
t=ms&k=Pda+database+software&w1=Manufacturing+
>
software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pd
>
a+database+software&w5=Database+management+software&w6=Database+marke
ting+so
> ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
> Database
> <http://groups.yahoo.com/gads?
t=ms&k=Database+management+software&w1=Manufac
>
turing+software&w2=Membership+database+software&w3=Database+mortgage+
softwar
>
e&w4=Pda+database+software&w5=Database+management+software&w6=Databas
e+marke
> ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management
software
> Database
> <http://groups.yahoo.com/gads?
t=ms&k=Database+marketing+software&w1=Manufact
>
uring+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware
>
&w4=Pda+database+software&w5=Database+management+software&w6=Database
+market
> ing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing
software
>
> _____
>
> YAHOO! GROUPS LINKS
>
> * Visit your group "vantage
<http://groups.yahoo.com/group/vantage> "
> on the web.
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
> <http://docs.yahoo.com/info/terms/> .
>
> _____
>
>
>
> [Non-text portions of this message have been removed]
>
I am trying to put together a report (Report Builder) that shows
employee actual clock-in times for the day. The field,
LaborHed.ActualClockInTime holds this information but it is in decimal
format. Is there a field that shows this information in a HH:MM
format? If not, how do I convert it?

Thanks!

- Erik
Eric,
There are some clock in reports in the files section of the
yahoogroup. You might download those and save some coding time.
Shirley Graver
Rubber Associates.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
rfc822 Compliance issue From: added by system POTENTIAL SPAM
Sent: Friday, April 28, 2006 10:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Actual Clock-In Times

I am trying to put together a report (Report Builder) that shows
employee actual clock-in times for the day. The field,
LaborHed.ActualClockInTime holds this information but it is in decimal
format. Is there a field that shows this information in a HH:MM
format? If not, how do I convert it?

Thanks!

- Erik






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/links



SPONSORED LINKS

Manufacturing
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing
+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=P
da+database+software&w5=Database+management+software&w6=Database+marketing+s
oftware&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software
Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+software&
w4=Pda+database+software&w5=Database+management+software&w6=Database+marketi
ng+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software

Pda
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+
software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pd
a+database+software&w5=Database+management+software&w6=Database+marketing+so
ftware&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufac
turing+software&w2=Membership+database+software&w3=Database+mortgage+softwar
e&w4=Pda+database+software&w5=Database+management+software&w6=Database+marke
ting+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufact
uring+software&w2=Membership+database+software&w3=Database+mortgage+software
&w4=Pda+database+software&w5=Database+management+software&w6=Database+market
ing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS

* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

_____



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