G
Guest
Hi All
Please could someone tell me if this is possible. I have 3 number fields -
TypeTime, ResearchTime and ProofTime. Users will enter in minutes the time
it has taken to complete a job eg. 70 , 30 and 35.
I have a query that then adds up these 3 fields as follows
TimeSpent=[TypeTime]+[ResearchTime]+[ProofTime] my answer is obviously 135.
I would then like to have another calculation to convert 135 to 2 hours 15
min. Dividing by 60 does not work as the value returned is 2.25.
Any help would be appreciated - even if to tell me that it is not possible.
Please could someone tell me if this is possible. I have 3 number fields -
TypeTime, ResearchTime and ProofTime. Users will enter in minutes the time
it has taken to complete a job eg. 70 , 30 and 35.
I have a query that then adds up these 3 fields as follows
TimeSpent=[TypeTime]+[ResearchTime]+[ProofTime] my answer is obviously 135.
I would then like to have another calculation to convert 135 to 2 hours 15
min. Dividing by 60 does not work as the value returned is 2.25.
Any help would be appreciated - even if to tell me that it is not possible.