Forum Discussion

DeanOusterhout's avatar
DeanOusterhout
Qrew Assistant Captain
9 years ago

How to show correct Hours and Minutes on Timesheet Summary Report

We have a timesheet table with hours column and minutes column by person and project and date.  Each person will have multiple records, usually one for morning and another for afternoon. The hours ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
9 years ago
I suggest that you create a new field called Duration which converts the separate hours and minutes into a duration.  

For example
Hours([my hours field]) + Minutes([my minutes field])  

You can either just use that single field on your Summary Report.