Re: Help with totaling the sum of time ("hh:mm) in a re****t ...
by sandinzz@[EMAIL PROTECTED]
Mar 28, 2008 at 03:14 AM
Hi
1. Do you save "Time" variable in Long data type?
2. You must convert sum of hours/minutes (Long type) in your re****t,
to string. For example: for three digit hours: hhh:mm
So, make conversion by dividing SumOfMinutes by 80 minutes (/ and %
for "trailing" minutes) to get HoursCount and MinutesCount - it's only
math.
Then make a string:
SumString = Format(HoursCount,@[EMAIL PROTECTED]
) & ':' & Format(MinutesCount,@[EMAIL PROTECTED]
)
or something like that.
Zoran
