Most valuable professional
  • Hot Topics

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

Hi again! This question continues the the thread How to calculate time remaining meetween Now() and tomorrow 8 am 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 1 2 3 Rate in ml/h 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

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel