Excel should let me divide and multiply time intervals

[b.garmon]

I would like to be able to perform math functions, including multiplication
and division, with time intervals. The results should be displayed in time
format. Example: I am tracking time as I prepare for a marathon. I enter the
total amount of time and the number of miles. I would like to see the average
time per mile. If I run 13 miles in 1 hour and 44 minutes, the forumula
should be 1:44:00/13, the result should be 8 minutes - formated as 8:00.
Instead, I get a result of .005556. I think that there are many uses for this
function for anyone who tracks time. I would like to see the funtionality
added to the next Excel version.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...heet.functions

[Pete_UK]

You can do this already - just format your result as [m]:ss and you
will get 8:00

Hope this helps.

Pete

b. garmon wrote:
> I would like to be able to perform math functions, including multiplication
> and division, with time intervals. The results should be displayed in time
> format. Example: I am tracking time as I prepare for a marathon. I enter the
> total amount of time and the number of miles. I would like to see the average
> time per mile. If I run 13 miles in 1 hour and 44 minutes, the forumula
> should be 1:44:00/13, the result should be 8 minutes - formated as 8:00.
> Instead, I get a result of .005556. I think that there are many uses for this
> function for anyone who tracks time. I would like to see the funtionality
> added to the next Excel version.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/comm...heet.functions

[Paul B]

Works for me, format your cell as h:mm:ss

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"b.garmon" <[email protected]> wrote in message
news:[email protected]...
> I would like to be able to perform math functions, including
multiplication
> and division, with time intervals. The results should be displayed in time
> format. Example: I am tracking time as I prepare for a marathon. I enter
the
> total amount of time and the number of miles. I would like to see the
average
> time per mile. If I run 13 miles in 1 hour and 44 minutes, the forumula
> should be 1:44:00/13, the result should be 8 minutes - formated as 8:00.
> Instead, I get a result of .005556. I think that there are many uses for
this
> function for anyone who tracks time. I would like to see the funtionality
> added to the next Excel version.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow
this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
>
http://www.microsoft.com/office/comm...heet.functions