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
<tbody>
</tbody>
<tbody>
</tbody>
The formula I came closest with:
Thanks in advance, as usually your answer will be duly appreciated
//Peter
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:
But not exactly=D3/(TEXT(C2;"hh:mm")*24)
Thanks in advance, as usually your answer will be duly appreciated
//Peter