Convert numerical value to time value

[paulpeyton]

I have fields that contain a figure in seconds. I then divide that by 3600 to get hours, but I may get 2.75 hours. How do I convert the .75 to read .45 (minutes)?
This issue is throwing off other calculations in my reports. Any assistance will be greatly appreciated.

 

[IdoMillet]

60 * 0.75 = 45

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[paulpeyton]

Thanks for the response. The issue is everything before the decimal. If I have 2.75, simply multiplying by 60 results in 165. How do I convert just the decimal without touching the hour?

 

[MrBillSC]

The following formula converts 1.75 to 1.45 using IdoMillet's suggestion:

Truncate(1.75) + (60 * (Remainder(1.75 * 100,100) / 10000))

Replace the "1.75" with your data field.

best of luck

 

[IdoMillet]

Assuming {@seconds} contains the number of seconds, this should work:
-------------------------------------------------------
ToText((Truncate({@seconds}/3600)),0) + " Hours and " +
ToText(60*Remainder({@seconds},3600),0) + " Seconds"
-------------------------------------------------------

hth,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[paulpeyton]

You guys are great! Thanks so much for the help! Works great!

 

[IdoMillet]

That should have been "Minutes", not "Seconds" at the end of the formula... )


CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com