Short Time Limitations

  • Thread starter Thread starter Spark
  • Start date Start date
S

Spark

Is there a way to obtain a sum in short time format that
is greater than 24 hours. I have a report showing how
many hours and minutes teams are not on the phone, but I
cannot figure out how to obtain a total greater than 24
hours.

Any help would be greatly apprecited.
 
That's because Access doesn't have that handy Excel format [h]:mm which can
do this.

You have to fake it. You could have your team input hours in one field and
minutes in another, then you can simply multiply the hours by 60 to turn
them into minutes and then add them to the minutes field. All your
arithmetic is done with this third field and the results are then turned
back into hours and minutes for display purposes.

eg You call your Hours + Minutes field AllMins. In a form/report footer you
would have 2 text boxes, one for the hours, one for the minutes. In one you
would have

=Int(Sum([AllMins])/60). The second text box has

=Sum([AllMins]) Mod 60

If you want the results to appear in a 00:00 format then combine the two
text boxes

=(Int(Sum([AllMins])/60) & ":" & Sum([AllMins]) Mod 60

Evi
 
Back
Top