Help with clock and time conversion and formula creation

[arnob216]

Hi

I want to make a sort of calculator in excel. The scenario is as follows:

Lets say I have 2 businesses and these have a certain stock level which gets converted to supply in certain times (hours and minutes only). What I want to make is to put Current clock time in 1 cell. Then depending on the "Stock to supply" conversion time, I want to know when I the stock will be fully converted. In more details:

Say, current time is 7 PM. My stock gets converted to supply in 2.5 hours (which means 2 hours and 30 minutes). How do I add this decimal number '2.5' to the 7 PM so that the result comes as 9:30 PM?
Here the 2.5 hours of conversion time will change depending on situations. Therefore, the figure could be any decimal number.

 

[HappierThan]

"Another thing I want to learn. How to convert 2.33 into 2 hours 20 mins or 2.5 into 2 hours 30 mins?"
With 2.33 in say H1 =TIME(H1,MOD(H1*60,60),0) gives you 2:19 if you format for h:mm (NOTE: 2.34 would give you 2:20)
With 2.50 in say H2 =TIME(H2,MOD(H2*60,60),0) gives you 2:30 if you format for h:mm
A new learning experience for me, a bit like finding out that kiloPascal, kilojoule, kilolitre, kilometre and millimetre are ALL pronounced as TWO SYLLABLES.
(Carl Sagan knew!)

 

[HappierThan]

With 2.33 in say H1 =TIME(H1,MOD(H1*60,60),0) gives you 2 hours, 19 minutes if you format for h "hours", mm "minutes"
With 2.50 in say H2 =TIME(H2,MOD(H2*60,60),0) gives you 2 hours, 30 minutes if you format for h "hours", mm "minutes"