Report builder guru question on time display

Yahoo Archive
1
The string function saves a lot of calculation, but first you have to
convert the decimal time to seconds-after-midnight, then it will work.

--- In vantage@y..., "Ronald van der Linden" <R.van.der.Linden@M...>
wrote:
> STRING(clockintime, "HH:MM AM")
>
> -----Original Message-----
> From: Stephen Freeman [mailto:stephenf@a...]
> Sent: maandag 28 januari 2002 21:56
> To: Vantage E groups (E-mail)
> Subject: [Vantage] report builder guru question on time display
>
>
> Our HR department uses a report similar to the Employee Clock
Report. She
> like the report except she doesn't like the way the time is
displayed.
> Example...instead of seeing the Vantage Clock Out time as 14.50 she
wants to
> see it as 2:30. Is their a formula I'm missing or is their a
different way
> of displaying this to make her happy?
>
>
>
> 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
Our HR department uses a report similar to the Employee Clock Report. She
like the report except she doesn't like the way the time is displayed.
Example...instead of seeing the Vantage Clock Out time as 14.50 she wants to
see it as 2:30. Is their a formula I'm missing or is their a different way
of displaying this to make her happy?
3
Try something like this:

STRING(IIF(NumHour > 12,NumHour - 12,NumHour),'>9') + ':' + STRING(60 *
Numeric(SUBSTRING(STRING(ClockInTime),INDEX(STRING(ClockInTime),'.'),6)),'99
') + IIF(NumHour >= 12,'PM','AM')

Where NumHour is
NUMERIC(SUBSTRING(STRING(ClockInTime),1,INDEX(STRING(ClockInTime),'.') - 1))

Oleg Tumarkin
Intelligent Systems Integration
(330) 335-5291
olegt@...

"Making Intelligent Use of Technology"

-----Original Message-----
From: Stephen Freeman [mailto:stephenf@...]
Sent: Monday, January 28, 2002 3:56 PM
To: Vantage E groups (E-mail)
Subject: [Vantage] report builder guru question on time display


Our HR department uses a report similar to the Employee Clock Report. She
like the report except she doesn't like the way the time is displayed.
Example...instead of seeing the Vantage Clock Out time as 14.50 she wants to
see it as 2:30. Is their a formula I'm missing or is their a different way
of displaying this to make her happy?



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=218512.1856015.3360178.1269402/D=egroupweb/S=17050071
83:HM/A=928902/R=0/*http://ad.doubleclick.net/clk;3788030;6800959;r%3fhttp:/
/www.verisign.com/cgi-bin/go.cgi?a=b229573240057000>

<http://us.adserver.yahoo.com/l?M=218512.1856015.3360178.1269402/D=egroupmai
l/S=1705007183:HM/A=928902/rand=825882814>

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
<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
<http://groups.yahoo.com/group/vantage/links>

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]
4
Instead of using laborhed.clockoutime, use laborhed.DspClockouttime.
It's already formatted as HH:MM.

But another cool conversion would be...

string(integer(laborhed.clockouttime) * 3600 +
(laborhed.clockouttime - integer(laborhed.clockouttime)) *
3600,"HH:MM:SS AM")

Lonnie

--- In vantage@y..., "Stephen Freeman" <stephenf@a...> wrote:
> Our HR department uses a report similar to the Employee Clock
Report. She
> like the report except she doesn't like the way the time is
displayed.
> Example...instead of seeing the Vantage Clock Out time as 14.50 she
wants to
> see it as 2:30. Is their a formula I'm missing or is their a
different way
> of displaying this to make her happy?
5
STRING(clockintime, "HH:MM AM")

-----Original Message-----
From: Stephen Freeman [mailto:stephenf@...]
Sent: maandag 28 januari 2002 21:56
To: Vantage E groups (E-mail)
Subject: [Vantage] report builder guru question on time display


Our HR department uses a report similar to the Employee Clock Report. She
like the report except she doesn't like the way the time is displayed.
Example...instead of seeing the Vantage Clock Out time as 14.50 she wants to
see it as 2:30. Is their a formula I'm missing or is their a different way
of displaying this to make her happy?



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/