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


Hi again! This question continues the the thread http://www.mrexcel.com/forum/excel-questions/733399-how-calculate-time-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 :crash: 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
Rate in ml/h =D3/?
The formula I came closest with:
=D3/(TEXT(C2;"hh:mm")*24)
But not exactly:confused: Thanks in advance, as usually your answer will be duly appreciated //Peter


This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of October 17, 2013.


For more resources for Microsoft Excel