Tallying time values in report footers

[CCS8DENI]

Is it possible to enter an expression in an unbound box that will vertically tally hours and not represent the result in 24 hour incriments?<br><br>ie 13:00, 7:00 and 10:00 will equal 30:00 not 6:00.<br><br>

 

[rochelle]

In your query that is the recordsource for the form, create a calculated column where the Field is HoursOnly: DatePart(&quot;h&quot;,[DateTimeField]). (This assumes that the name of your field is DateTimeField.)&nbsp;&nbsp;<br><br>This will create an integer field of hours only called HoursOnly in your recordsource.&nbsp;&nbsp;Then, in the form footer place a calculated field whose controlsource is =Sum([HoursOnly]).