Time / Number

  • Thread starter Thread starter That's Confidential
  • Start date Start date
T

That's Confidential

I have a cell that contains the [hh].mm as 123.00 Now, i want to divide this
by another general number in another cell which is 23. Any advice as to how
I can get an answer but have it formatted so that it works it out as hours,
so I am looking for an answer of about 5.30 (or 5 and a half hours!)

Thanks in advance

PS: I tried =(D7*24)/(D8), however I have to have the cell formatted as
general, and so I am not actually getting minutes back, but a number which
can be above 60
 
Hi

I've just recreated your scenario, using =(time/divisor)*24 and I've got
5.347826 (formmated as General).
Is that what you are looking for?
 
Hi
if you want the result as time format simply divide it by
23:
=D7/23
and apply a time format.

If you want to display it as a decimal (e.g. 5:30 = 5.50)
use the formula
=(D7/23)*24
 
Back
Top