Crystal reports Time Conversion Help

Yahoo Archive
1
Much easier than the one I just sent.



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerard Wadman
Sent: Friday, May 25, 2007 2:01 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal reports Time Conversion Help



Never mind, I figured it out.

cTime(( {systime}/3600 ) /24)

Gerard M Wadman

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

978/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>

This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gerard Wadman
Sent: Friday, May 25, 2007 1:13 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal reports Time Conversion Help

How do I convert the systime field to a time format HH:MM:SS?

I divide by 3600, I get the correct hour number but the minutes and
seconds show up as a decimal of the remainder.

Anyone here know how to convert this?

Thanks,

Gerard M Wadman

MCSE, MCP+I, A+, NET+

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

866/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>
<http://www.scandius.com/ <http://www.scandius.com/> >

This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses

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

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





[Non-text portions of this message have been removed]
2
How do I convert the systime field to a time format HH:MM:SS?

I divide by 3600, I get the correct hour number but the minutes and
seconds show up as a decimal of the remainder.



Anyone here know how to convert this?



Thanks,



Gerard M Wadman

MCSE, MCP+I, A+, NET+

Sr. Network Systems Engineer

Scandius BioMedical Inc.



11A Beaver Brook Road

Littleton, MA 01460



978/486-4088 x 124

866/486-4108 (fax)



http://www.scandius.com/





This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses





[Non-text portions of this message have been removed]
3
Never mind, I figured it out.





cTime(( {systime}/3600 ) /24)









Gerard M Wadman

Sr. Network Systems Engineer



Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460



978/486-4088 x 124

978/486-4108 (fax)



http://www.scandius.com/





This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerard Wadman
Sent: Friday, May 25, 2007 1:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal reports Time Conversion Help



How do I convert the systime field to a time format HH:MM:SS?

I divide by 3600, I get the correct hour number but the minutes and
seconds show up as a decimal of the remainder.

Anyone here know how to convert this?

Thanks,

Gerard M Wadman

MCSE, MCP+I, A+, NET+

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

866/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>

This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses

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





[Non-text portions of this message have been removed]
4
I haven't used this in a while so be sure to test. This is one of those
that is somewhat painful.



Numbervar MM;

Numbervar HH;

//set TimeFeature equal to the Decimal time you want converted

NumberVar TimeFeature := {LaborHed.ClockInTime};





MM := round(((( TimeFeature * 100) mod 100) * .0060),4);

HH := TimeFeature - ((( TimeFeature * 100) mod 100) * .01);



Totext(HH) + ':' + Right(totext (MM,2),2);



Bruce Butler

IT Manager

Knappe & Koester, Inc.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gerard Wadman
Sent: Friday, May 25, 2007 1:13 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal reports Time Conversion Help



How do I convert the systime field to a time format HH:MM:SS?

I divide by 3600, I get the correct hour number but the minutes and
seconds show up as a decimal of the remainder.

Anyone here know how to convert this?

Thanks,

Gerard M Wadman

MCSE, MCP+I, A+, NET+

Sr. Network Systems Engineer

Scandius BioMedical Inc.

11A Beaver Brook Road

Littleton, MA 01460

978/486-4088 x 124

866/486-4108 (fax)

http://www.scandius.com/ <http://www.scandius.com/>

This e-mail is for the use of the intended recipient(s) only. If you
have received this e-mail in error, please notify the sender immediately
and then delete it. If you are not the intended recipient, you must not
use, disclose or distribute this e-mail without the author's prior
permission. We have taken precautions to minimize the risk of
transmitting software viruses, but we advise you to carry out your own
virus checks on any attachment to this message. We do not accept
liability for any loss or damage caused by software viruses

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





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