Question Involving Time/Rate

[Misterchipper]

I have 2 pieces of data--1 involving time and another involving output of water.

What I would like to do is Subtract Time 1 from Time 2 and Output 1 from Output 2 to determine the relative rate between these 2...However, my excel converts the time into some strange function.

Time 19:44 20:20
Output 40 220

 

[T. Valko]

I have 2 pieces of data--1 involving time and another involving output of water.

What I would like to do is Subtract Time 1 from Time 2 and Output 1 from Output 2 to determine the relative rate between these 2...However, my excel converts the time into some strange function.

Time 19:44 20:20
Output 40 220

C1 = 20:20
B1 = 19:44

=C1-B1

Result = 0:36

 

[Misterchipper]

Yes 0:36 is the answer for the difference in time--yet I want to perform the following formula

220/0:36--which will provide me a rate. For some reason, excel is treating 0:36 as 0.02 and giving me an absurd answer 88000. The answer should be something around 400.

Any help is appreciated....

 

[T. Valko]

Yes 0:36 is the answer for the difference in time--yet I want to perform the following formula

220/0:36--which will provide me a rate. For some reason, excel is treating 0:36 as 0.02 and giving me an absurd answer 88000. The answer should be something around 400.

Any help is appreciated....

How about 366.6667?

C2 = 220

=C2/((C1-B1)*24)

Format as General or Number

 

[Misterchipper]

Well that works!

Why did you multiply by 24?

 

[T. Valko]

Well that works!

Why did you multiply by 24?

To convert the time value 0:36 into a decimal value to be compatible with the decimal value of 220.