Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Jogging Log and Elapsed time formats
I'm attempting to create a spreadsheet to log my jog distances, and times.
I'm wanting to be able to type in the time in a standard format (i.e. 17:38 = 17 minutes and 38 seconds), and be able to take that value from the cell 17:38 and display a pace in minutes/mile of the same format (minutes:seconds / mile) by dividing the displayed time 17:38 by the distance. Example: A2= 17:38 (min:sec) A3=2 (miles) A4 = A2/A3 (displayed as min:sec/mile) I've attempted to use many of the built in time functions, but they seem to all be based on an absolute time, and not an elapsed time. If anybody has any ideas, I would greatly appreciate them! Thanks, and keep on pluggin' and chuggin' those numbers! Mike |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Jogging Log and Elapsed time formats
Hi Mike,
There is no differnce technically between "absolute time" and elapsed time; both are the time since a zero point. Your formula gives me 8:49 in A3. Note that Excel interprets 17:38 as 17 hours and 38 minutes; insignificant in your example, but it might get you into problems if you enter times over an hour. Then use 0:17:38 format for all time entries. If you want the format as descriptive as you post, format A3 Custom as "hh:mm:ss "/mile" -- Kind regards, Niek Otten Microsoft MVP - Excel "Margle" wrote in message ... | I'm attempting to create a spreadsheet to log my jog distances, and times. | I'm wanting to be able to type in the time in a standard format (i.e. 17:38 = | 17 minutes and 38 seconds), and be able to take that value from the cell | 17:38 and display a pace in minutes/mile of the same format (minutes:seconds | / mile) by dividing the displayed time 17:38 by the distance. | Example: | A2= 17:38 (min:sec) | A3=2 (miles) | A4 = A2/A3 (displayed as min:sec/mile) | I've attempted to use many of the built in time functions, but they seem to | all be based on an absolute time, and not an elapsed time. If anybody has | any ideas, I would greatly appreciate them! Thanks, and keep on pluggin' and | chuggin' those numbers! | | Mike |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Jogging Log and Elapsed time formats
<"hh:mm:ss "/mile"
That should have been hh:mm:ss "/mile" between quotes. Don't enter the outer quotes in the Type box. I hope you're still following. -- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... | Hi Mike, | | There is no differnce technically between "absolute time" and elapsed time; both are the time since a zero point. | | Your formula gives me 8:49 in A3. | | Note that Excel interprets 17:38 as 17 hours and 38 minutes; insignificant in your example, but it might get you into problems if | you enter times over an hour. Then use 0:17:38 format for all time entries. | | If you want the format as descriptive as you post, format A3 Custom as "hh:mm:ss "/mile" | | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Margle" wrote in message ... || I'm attempting to create a spreadsheet to log my jog distances, and times. || I'm wanting to be able to type in the time in a standard format (i.e. 17:38 = || 17 minutes and 38 seconds), and be able to take that value from the cell || 17:38 and display a pace in minutes/mile of the same format (minutes:seconds || / mile) by dividing the displayed time 17:38 by the distance. || Example: || A2= 17:38 (min:sec) || A3=2 (miles) || A4 = A2/A3 (displayed as min:sec/mile) || I've attempted to use many of the built in time functions, but they seem to || all be based on an absolute time, and not an elapsed time. If anybody has || any ideas, I would greatly appreciate them! Thanks, and keep on pluggin' and || chuggin' those numbers! || || Mike | | |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Jogging Log and Elapsed time formats
<"hh:mm:ss "/mile"
That should have been hh:mm:ss "/mile" between quotes. Don't enter the outer quotes in the Type box. I hope you're still following. You can also do it without the quote marks as long as you use backslashes in front of the format's meta-characters. hh:mm:ss /\mil\e Rick |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Jogging Log and Elapsed time formats
Thanks, Rick!
-- Kind regards, Niek Otten Microsoft MVP - Excel "Rick Rothstein (MVP - VB)" wrote in message ... | <"hh:mm:ss "/mile" | | That should have been hh:mm:ss "/mile" between quotes. Don't | enter the outer quotes in the Type box. I hope you're still following. | | You can also do it without the quote marks as long as you use backslashes in | front of the format's meta-characters. | | hh:mm:ss /\mil\e | | Rick | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Elapsed time question | Excel Discussion (Misc queries) | |||
Need Elapsed Time Help | Excel Worksheet Functions | |||
Excel sheet for workout jogging time and graph | New Users to Excel | |||
elapsed time | Excel Worksheet Functions | |||
Elapsed time | Excel Discussion (Misc queries) |