Payroll Hours-Minutes

Yahoo Archive
1
Thanks, everybody, this was a real DUH on my part -- DspClockInTime and
OutTime is just what I need.

Lydia


-----Original Message-----
From: Lonnie Drew [mailto:lonniedrew@...]
Sent: Friday, September 27, 2002 11:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Payroll Hours-Minutes


Look at DspClockInTime and DspClockOutTime, may be what you need.

If not, how about something like...

HourHundredChar = string(HourHundred).
HourMin = substring(HourHundredChar,1,2) + ":" + string(integer
(substring(HourHundredChar,4,2)) * .6)

...I didn't test it, but it should be close.

Lonnie

--- In vantage@y..., Lydia Coffman <lcoffman@c...> wrote:
> Hi!
>
> Well, your testimonials about not having time clocks really helped,
now I
> have a related challenge:
>
> Is there a way to convert the Vantage time (in Report Builder) from
> Hours.Hundredths to Hours.Minutes? The gal who will be doing the
time
> reporting into our ADP system is used to minutes (what the time
clock says)
> instead of hundredths of hours. I've been puzzling over this for a
couple
> of days, so I thought it was time to ask the experts. I know a
simple
> calculation would work on the hundredths:minutes side, but can't
figure out
> what to do about the hours. Anybody done this already, have a hint
or think
> I should give it up?
>
> Thanks and happy Friday!
>
> Lydia
> Canyon Engineering Products
> lcoffman@c...
> 661-294-0084



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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
Hi!

Well, your testimonials about not having time clocks really helped, now I
have a related challenge:

Is there a way to convert the Vantage time (in Report Builder) from
Hours.Hundredths to Hours.Minutes? The gal who will be doing the time
reporting into our ADP system is used to minutes (what the time clock says)
instead of hundredths of hours. I've been puzzling over this for a couple
of days, so I thought it was time to ask the experts. I know a simple
calculation would work on the hundredths:minutes side, but can't figure out
what to do about the hours. Anybody done this already, have a hint or think
I should give it up?

Thanks and happy Friday!

Lydia
Canyon Engineering Products
lcoffman@...
661-294-0084
3
Lydia,

Check out Config Maintenance, company, your company, Module Config, Job
Management config, labor/time format.
I think this changes it across the board.

Aaron Hoyt
Design Standards

-----Original Message-----
From: Lydia Coffman [mailto:lcoffman@...]
Sent: Friday, September 27, 2002 2:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Payroll Hours-Minutes


Hi!

Well, your testimonials about not having time clocks really helped, now I
have a related challenge:

Is there a way to convert the Vantage time (in Report Builder) from
Hours.Hundredths to Hours.Minutes? The gal who will be doing the time
reporting into our ADP system is used to minutes (what the time clock says)
instead of hundredths of hours. I've been puzzling over this for a couple
of days, so I thought it was time to ask the experts. I know a simple
calculation would work on the hundredths:minutes side, but can't figure out
what to do about the hours. Anybody done this already, have a hint or think
I should give it up?

Thanks and happy Friday!

Lydia
Canyon Engineering Products
lcoffman@...
661-294-0084





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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
Look at DspClockInTime and DspClockOutTime, may be what you need.

If not, how about something like...

HourHundredChar = string(HourHundred).
HourMin = substring(HourHundredChar,1,2) + ":" + string(integer
(substring(HourHundredChar,4,2)) * .6)

...I didn't test it, but it should be close.

Lonnie

--- In vantage@y..., Lydia Coffman <lcoffman@c...> wrote:
> Hi!
>
> Well, your testimonials about not having time clocks really helped,
now I
> have a related challenge:
>
> Is there a way to convert the Vantage time (in Report Builder) from
> Hours.Hundredths to Hours.Minutes? The gal who will be doing the
time
> reporting into our ADP system is used to minutes (what the time
clock says)
> instead of hundredths of hours. I've been puzzling over this for a
couple
> of days, so I thought it was time to ask the experts. I know a
simple
> calculation would work on the hundredths:minutes side, but can't
figure out
> what to do about the hours. Anybody done this already, have a hint
or think
> I should give it up?
>
> Thanks and happy Friday!
>
> Lydia
> Canyon Engineering Products
> lcoffman@c...
> 661-294-0084
5
Try:
Clock_In_Time_HH = integer(ClockInTime)
Clock_In_Time_MM = (ClockInTime - integer(ClockInTime)) * 60

Patrick

-----Original Message-----
From: Lydia Coffman [mailto:lcoffman@...]
Sent: Friday, September 27, 2002 1:22 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Payroll Hours-Minutes


Hi!

Well, your testimonials about not having time clocks really helped, now I
have a related challenge:

Is there a way to convert the Vantage time (in Report Builder) from
Hours.Hundredths to Hours.Minutes? The gal who will be doing the time
reporting into our ADP system is used to minutes (what the time clock says)
instead of hundredths of hours. I've been puzzling over this for a couple
of days, so I thought it was time to ask the experts. I know a simple
calculation would work on the hundredths:minutes side, but can't figure out
what to do about the hours. Anybody done this already, have a hint or think
I should give it up?

Thanks and happy Friday!

Lydia
Canyon Engineering Products
lcoffman@...
661-294-0084





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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/