Microsoft Office Tutorials and References

In Depth Information

**Calculating Elapsed Time over Days**

The trick is to correctly calculate the time between the start and end values.

The hour portion of both the start and end values is determined with the

HOUR function, and then one value is subtracted from the other. The result

of this subtraction is added to the precalculated number of hours from the

count of days. Note that minutes are ignored — perhaps you can figure out

how to modify the formula to take seconds into account!