this just gives the hours, not the units. for the units you need to perform a conversion. Are these times for the details, and you will sum the details to create a total of units for a week or other time period? If so, you might want to do something like:
local numbervar thisTime:=val({EstimatedHours}) + val({EstimatedMinutes}) / 60;
local numbervar thisUnit:=0;
shared numbervar totalUnits; //(optional, if aggregate needed)
if thisTime>=1.75 and thisTime <2 then
thisUnit :=1
else
if thisTime >= ... and thisTime < ... then
thisUnit:=2...
I think you get the idea.
totalUnits := totalUnits + thisUnit; //(optional, for the aggregate)
thisUnit //display the units calculated
if you use the aggregates, you will need a formula to display them and one to reset to 0 when the group changes.
IP Logged
