Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Recording elapsed time
What formula do I use for elapsed time so I can calculate calories/hour from
my exercise routine, for example? The routines vary in lengthI can calculate average time and average calories but is there a way I can use the hour:minute:second format (or some other elapsed time format) to divide the calories by, or do I have to convert all times to hours, for example, and proceed that way? In what format do I enter the time data? I am using Office XP Professional with Publisher Version 2002. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Recording elapsed time
Hi Kap,
Perhaps this would be ok ? If times are entered in 24 hour format with hours and minutes e.g. in columns A and B for start and stop: 12:00 12:15 13:10 14:15 23:00 00:15 The hours spent can be calculated as: =IF(B1<A1,ROUND((B1-A1+1)*24,2),ROUND((B1-A1)*24,2)) formatted as number to 2 decimal places. Hth Anthony "kap" wrote: What formula do I use for elapsed time so I can calculate calories/hour from my exercise routine, for example? The routines vary in lengthI can calculate average time and average calories but is there a way I can use the hour:minute:second format (or some other elapsed time format) to divide the calories by, or do I have to convert all times to hours, for example, and proceed that way? In what format do I enter the time data? I am using Office XP Professional with Publisher Version 2002. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
synchronizing timestamp feature with time on video software. | Excel Discussion (Misc queries) | |||
Want to measure macro elapsed time. | Excel Discussion (Misc queries) | |||
Calculating Time elapsed | Excel Worksheet Functions | |||
Calculating elapsed time | Excel Worksheet Functions | |||
Calculating a rate for elapsed time? | Excel Discussion (Misc queries) |