Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Student needs formula
A marathon race begins at 8.30am
Contestants stop for water break at 8.30.22 until 8.30.55 The race ends at 10.55.16am How long did the race take to complete and how long was their water break? The race took 2hrs 25mins 16secs to complete Water break 33 secs Easy enough to work out in your head but how do you get excel to work it out? I'm a very new student with excel(2000) formulae and would like to examine how it's done? Please. TIA Mickey |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Student needs formula
Hi,
As an example: In A1 put 08:30:00 Excel recognises data is entered as time (hh:mm:ss) in B1 put 10:55:16 in C1 put "=B1-A1" without quotation marks (") formula for simple subtraction C1 should show 02:25:16 in D1 put 08:30:22 in E1 put 08:30:55 in F1 put "=E1-D1" (again without quotation marks) F1 should be 00:00:33 HTH "Mickey Mouse" wrote: A marathon race begins at 8.30am Contestants stop for water break at 8.30.22 until 8.30.55 The race ends at 10.55.16am How long did the race take to complete and how long was their water break? The race took 2hrs 25mins 16secs to complete Water break 33 secs Easy enough to work out in your head but how do you get excel to work it out? I'm a very new student with excel(2000) formulae and would like to examine how it's done? Please. TIA Mickey |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Student needs formula
Mickey,
You can also deduce that it was a very hot day, as the runners needed to stop for water after a mere 22 seconds of exertion. NickHK "Mickey Mouse" <. wrote in message ... A marathon race begins at 8.30am Contestants stop for water break at 8.30.22 until 8.30.55 The race ends at 10.55.16am How long did the race take to complete and how long was their water break? The race took 2hrs 25mins 16secs to complete Water break 33 secs Easy enough to work out in your head but how do you get excel to work it out? I'm a very new student with excel(2000) formulae and would like to examine how it's done? Please. TIA Mickey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Student loan formula | Excel Worksheet Functions | |||
Student Creating Formula | New Users to Excel | |||
Pivot table and formula help??STUDENT NEED HELP.... | Excel Discussion (Misc queries) | |||
how to match Id and Student ID | Excel Worksheet Functions | |||
Trouble with formula on Student 2006 learning essentials template | Excel Worksheet Functions |