Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: time calcualtion Post Reply Post New Topic
Author Message
john_doe
Newbie
Newbie
Avatar

Joined: 18 Mar 2008
Location: Malaysia
Online Status: Offline
Posts: 4
Quote john_doe Replybullet Topic: time calcualtion
    Posted: 18 Mar 2008 at 7:00pm

hi everyone,

I'm new to crystal report 2008, wish that you all can help.
I'm trying to create a graph chart using crystal report that using ms Access database. Below was the some example of database.

ID    Condition           Time              Floor

1          1              10:54:48 AM         1
2          1              10:54:48 AM         2
3          0              10:55:02 AM         2
4          0              10:55:16 AM         1

 

With these database, i'm going to calculate the time for each floor using the condition "1" and "0"( "1" for start time and "0" for end time).
below was the basic theory for the calculation


(Floor 1 with time (10:54:48) and condition="0" ) - ( Floor 1 with time (10:55:16) and condition="1" )

and the result should be 18 second. the same goes floor no 2

(Floor 2 with time (10:54:48) and condition="0" ) - ( Floor 2 with time (10:55:02) and condition="1" )
 
and the result should be 14 second.
 
I'm sorry guy, it looked simple but i need to know how the formula is created for the calculation.
 


 

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.