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.
I created two fields Hours(number type) Minuts(number type) and Total(number type). Total calculation is as follow
(Hours * 60 ) + Minuts
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