Adding Times

This tip explains how to add time fields together, when the sum of the fields is greater than 24 hours.

It uses two scenarios.

The first is adding two different fields together either in a query, a form or a report.

The second is summing all the values in the one field, i.e. either in a continuous form or on a report.

The syntax changes slightly depending on whether the calculation is in a query a form or a report.

Note: Change the [TimeExample] fields to the name of your fields.

This first one is the adding of two time fields:

Query Example

The following would be entered into the first row of the a blank column in the query.

SumTime: Format(([TimeExamples]+[TimeExamples1])*24,"#.0" & " Hours")

Form or Report Example:

Add an unbound text box to a form or a report and enter the following within this text box.

=Format(([TimeExamples]+[TimeExamples1])*24,"#.0" & " Hours")

This second scenario is if you wish to sum all the values in the one field, i.e. for either a continuous form or in a report.

To do this:

Add an unbound text box to the form or the report.

In a continuous form you would normally (but not always) put this in the form footer.

On a report you would normally (but not always) put this in the footer of the section of a grouped report where the field is you would like to add together.

To this unbound text box add the following formula:

=Format(Sum([TimeExamples])*24,"#.0") & " Hours"

These formats will display the result as: 136.8 hours. The results are rounded and the final part is in decimals, so you may wish to change these back to minutes, depending on what you are going to do with the result.