Print Page | Close Window

Calculating # of seconds input in DateTime range

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4256
Printed Date: 01 May 2024 at 4:55pm


Topic: Calculating # of seconds input in DateTime range
Posted By: nima_h
Subject: Calculating # of seconds input in DateTime range
Date Posted: 15 Sep 2008 at 8:43am
Hi All,
Does anyone know how to calculated the total time inputted in to a DateTime parameter of type Range value?

 

For example if a user inputs: 1 to 3:30, and 8 to 10. I need to calculate the Delta and have 2.5 + 2 = 4.5 hours.


I need to do this to calculate the number of hours report was run for.


Thanks in advance,

Nima


Print Page | Close Window