2 Replies Latest reply on Jul 2, 2010 5:33 AM by lamp

    calcolation times

    lamp

      Title

      calcolation times

      Post

      Dear All,

      I have a table Queries and QueriesHistory. eache Query have a list of QueryHistory. We want to put field to know how log we spent on each QueryHistory all QueryHistory time will be added and the total should be shown on query record. At the end we should know how log we spent on each Query.

      my database relation is

      Query.QueryID=QueryHistory.QueryID

      What I have done sofar.

      QueryHistory Table

      I created two fields Hours(number type) Minuts(number type) and Total(number type). Total calculation is as follow

      (Hours * 60 ) + Minuts

      Query Table

      I created a field TotalTime(number type). Then created a script as follow

      Go to related record and get the QueryID

      search QueryHistory for that ID

      Sum all Totals from QueryHistory

      show the result to TotalTime

      Sofar it is working ok with the values but not accurate the result in TotalTime come in minut I want to change it in hours and minuts. For example if the total works on a Query took 4 hours and 25 minutes it comes 265. How can I make it look like 4.25 hours?

      Please let me know if you need more information.

      I appreciate your help.

      Thanks in advance

      Lamp