Solved Time calculation answer in another formula

mmcconaghy August 13, 2012 at 14:19:19

Unless I'm missing something the formula to get the time difference is simply =End_Time minus Start_Time: A B C 1) 8:00 11:00 3:00 The formula in C1 is simply =B1-A1 Make sure that C1 is formatted as a TIME type cell. MIKE http://www.skeptic.com/

Yes, but I need to take that answer and apply it to another formula (volume/time) and that is where the answer is failing in my formula. I need to take the time answer (say 8 minutes) and use that to divide the volume to get a flow rate.

mmcconaghy August 13, 2012 at 15:17:13

OK, to covert the Time Value to a decimal number, Format cell C1 as Number and use the formula =(B1-A1)*24 See how that works. MIKE http://www.skeptic.com/

Using the followng as the data (9:59 AM start time and 10:08 AM as the stop time), your fomula returned 0.15 with answer cell formated as a decimal number. If I use the (B2-B1) formula and format the answer cell as "Custom" [m] format, I get the right answer (9) but it does not calculate as "9" in the second formula.

mmcconaghy August 13, 2012 at 15:56:48

✔ Best Answer

Minor modification to get down to Minutes: =((B1-A1)*24)*60 EDIT ADDED: Can you figure out how to get SECONDS? :-) MIKE http://www.skeptic.com/

Thanks. That worked, and I was even able to combine the equations and still get it to work.

FYI - Yes to get down to seconds, I assume the equation adjusts to =(((B1-A1)*24)*60)*60 :-)

mmcconaghy August 13, 2012 at 16:19:34

Just so you know, you can also combine the multipliers: 24 * 60 = 1440 so you could use: =((B1-A1)*1440) A wee bit shorter and only one multiplier. MIKE http://www.skeptic.com/