Add a calculated field to your report for the translation using the
statement below
iif(ActLunchInTime > 12.99,STRING((ActLunchInTime - 12) * 3600,
"HH:MM"),STRING(ActLunchInTime * 3600, "HH:MM"))
If you want the seconds as well make the string "HH:MM:SS"
-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Tuesday, October 15, 2002 2:20 PM
To: vantage@yahoogroups. Com
Subject: [Vantage] RB time calculation
How would I go about converting the LunchInTime & LunchOutTime out of the
Labor Hed table from decimal format to hours/minutes format?
====================================================================== Nora
Story
Spectra Technologies
Project Administrator
1505 Royal Parkway
Phone: 817-540-4475 ext.105
Euless, Texas 76040
Fax: 817-540-4439
Nora_Story@...
======================================================================
[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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
[Non-text portions of this message have been removed]
statement below
iif(ActLunchInTime > 12.99,STRING((ActLunchInTime - 12) * 3600,
"HH:MM"),STRING(ActLunchInTime * 3600, "HH:MM"))
If you want the seconds as well make the string "HH:MM:SS"
-----Original Message-----
From: Nora Story [mailto:Nora_Story@...]
Sent: Tuesday, October 15, 2002 2:20 PM
To: vantage@yahoogroups. Com
Subject: [Vantage] RB time calculation
How would I go about converting the LunchInTime & LunchOutTime out of the
Labor Hed table from decimal format to hours/minutes format?
====================================================================== Nora
Story
Spectra Technologies
Project Administrator
1505 Royal Parkway
Phone: 817-540-4475 ext.105
Euless, Texas 76040
Fax: 817-540-4439
Nora_Story@...
======================================================================
[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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
[Non-text portions of this message have been removed]