Discussion Locked

Calculating Elapsed Times in Excel 97

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way to track & calculate elapsed time (minutes:seconds) in Excel. I am currently doing a time study of some network applications over two different connections and need to track the time to access each app, each day, over a two week period and then calculate the averages. I've attempted to use the custom number format with absolutely no luck. Any help is appreciated!

5 replies

by roc180

You want to use the Time Format for your columns. And then write a few formulas to calculate elapsed time and average time. If you contact me with your email address I will email you a spreadsheet that details how to set up the formats and the calculations for elapsed time and average time. Neal Martinelli

This discussion is closed to new replies.