Tallying time values in report footers Tallying time values in report footers CCS8DENI (TechnicalUser) (OP) 20 Jul 00 10:41 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?ie 13:00, 7:00 and 10:00 will equal 30:00 not 6:00. RE: Tallying time values in report footers rochelle (Programmer) 24 Jul 00 10:24 In your query that is the recordsource for the form, create a calculated column where the Field is HoursOnly: DatePart("h",[DateTimeField]). (This assumes that the name of your field is DateTimeField.) This will create an integer field of hours only called HoursOnly in your recordsource. Then, in the form footer place a calculated field whose controlsource is =Sum([HoursOnly]).