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!