I have a form that tracks total time spent on a project in hours and min. It contains the start time, Completed time and Total time fields. The problem is that I the total time field will only store the value if it is a text field and on the report I need to calculate the sum of all the totaltimes column in the report footer. I cant get it to calculate the text data format.
TotalTime (number Format)
Private Sub Command6_Click()
If [Completetime] > [starttime] Then
TotalTime.Value = Format([Completetime] - [starttime], "hh:nn")
TotalTime.Value = Format([Completedtime] + 1 - [starttime], "hh:nn")