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

L

lelkes

New Member
Joined
Oct 1, 2013
Messages
26
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 :oops: 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)
Click to expand...
But not exactly:confused:

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

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Sort by date Sort by votes
Can you explain a little bit better what it is you are trying to do? In order to get ml/h, you are trying to divide D3 (350 ML) by how many hours?
 
Upvote 0
I don't think C2 is returning a difference of hours. For that you should use a formula such as:

=(TODAY()+1+"08:00:00"-NOW())*24

Then make sure that the cell format is general. (when selected on the cell, use Ctrl+Shift+~)

Once that is corrected, the simpler formula should work just fine.
 
Upvote 0
To do the division don't you need a singe unit (minutes or seconds) and then convert the result?
so it would be 350 ml / (373/60) h yielding 56.3
 
Upvote 0
bschwartz said:
I don't think C2 is returning a difference of hours. For that you should use a formula such as:

=(TODAY()+1+"08:00:00"-NOW())*24

Then make sure that the cell format is general. (when selected on the cell, use Ctrl+Shift+~)

Once that is corrected, the simpler formula should work just fine.
Click to expand...
Sorry but it don´t work either:
The time remaining is: 5:30 (hh:mm)
Manually calculated = 350/5.3 =>66 ml/h
C2=(TODAY()+1+"08:00:00"-NOW())*24 --> D3/C2 => 11,9 ml/h
 
Upvote 0
You must log in or register to reply here.

Similar threads

tezza
  • Question
Put shift times into category columns
Replies
2
Views
1K
tezza
tezza
Major Aly
  • Solved
Converting/Using a complicated formula for excluding working hours in VBA
Replies
6
Views
1K
Dave Patton
D
B
  • Question
Error catching formula - help with VLOOKUP between dates and last valid date pair
Replies
1
Views
988
earthworm
earthworm
L
  • Solved
Many many Q's - conditional formatting plus IF, VLOOKUP queries
Replies
5
Views
614
Alex Blakenburg
A
E
  • Question
Calculating total time over 24 hours ... [h]:mm does not work
2 3
Replies
25
Views
15K
lhartono
L

Forum statistics

Threads
1,214,929
Messages
6,122,317
Members
449,081
Latest member
tanurai

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top