divide an integer with time (in format "hh:mm")

[lelkes]

Hi again!
This question continues the the thread http://www.mrexcel.com/forum/excel-...ime-remaining-meetween-now-tomorrow-8-am.html

For the best part of the last six hours I've tried to figure out how to proceed, but failed completely So once again, I've to ask for your help....

Let's say I want to calculate the infusion rate in ml/h

A	B	C	D
1	Opened	Time Remaining (hh:mm)	Volume in ml
2		=(TODAY()+1+"08:00:00")-NOW()
3	=NOW()		350

<tbody>
</tbody>

Rate in ml/h

=D3/?

<tbody>
</tbody>

The formula I came closest with:

=D3/(TEXT(C2;"hh:mm")*24)

But not exactly

Thanks in advance, as usually your answer will be duly appreciated
//Peter

 

[mfexcel]

I think your original approach is correct; just that you don't need to convert it into text and format with HH:MM again.
simply try this
=D3/((TODAY()+1+"08:00"-NOW())*24)