Excel should let me divide and multiply time intervals

B

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/com...dg=microsoft.public.excel.worksheet.functions
 
P

Pete_UK

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

Hope this helps.

Pete
 
P

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 said:
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.
Click to expand...
http://www.microsoft.com/office/com...dg=microsoft.public.excel.worksheet.functions
 
Top