AnsweredAssumed Answered

calcolation times

Question asked by lamp on Jul 2, 2010
Latest reply on Jul 2, 2010 by lamp


calcolation times


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


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