I have time entered in the form: hh:mm:ss and distance in kilometres. I am
trying to calculate my pace in the form: minutes per kilometre. Problem is
that Excel interprets any digits entered as time to be "time of day" as
opposed to a cumulative time. Therefore, when I try to calculate
time/distance, I get a blank cell (no error message).