hatemgamil
Programmer
- Mar 18, 2010
- 41
hi all
i have a field in report "Delay Time" and it's type is string
i want to get summary for this field but i dont know how so i want some help
this field looks like that hh:mm
eg DelayTime
09:03
02:08
01:09
i want to get total to
DelayTime
09:03
02:08
01:09
------------------------------------------
Total 12:20
taking care i want to increment hh (hours) if total number of minutes exceeds 60 min and the hh is up to 23
and make it 1 day if number of hours exceeds 24
thnx
i have a field in report "Delay Time" and it's type is string
i want to get summary for this field but i dont know how so i want some help
this field looks like that hh:mm
eg DelayTime
09:03
02:08
01:09
i want to get total to
DelayTime
09:03
02:08
01:09
------------------------------------------
Total 12:20
taking care i want to increment hh (hours) if total number of minutes exceeds 60 min and the hh is up to 23
and make it 1 day if number of hours exceeds 24
thnx