To be honest, Peo, I wasn't saying that Ashish's interpretation was
incorrect, merely that it was different from what some of the rest of us had
assumed. The OP's intention wasn't clear, as his example wasn't internally
consistent.

My guess would have agreed with Martin's (and yours), but the OP hasn't
confirmed what was wanted and may not have realised the difference (which
was why I posted what I had *hoped* was clarification).
--
David Biddulph

"Peo Sjoblom" wrote in message
...
What is strange about it? Your interpretation is the same as mine and
David's
that 0.84 hour = 50 minutes and 24 seconds whereas the other formula
incorrectly returns 1 hours and 24 minutes as a text value

"MartinW" wrote in message
...
That's a very strange post David. What does it mean?

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
You will have realised, I hope, that Ashish's formula converts your 0.84
into 0:84:00, in other words 1:24:00 in h:mm:ss.

Other users have assumed that by 0.84 you mean 0.84 hours, or 0:50:24 in
h:mm:ss.
--
David Biddulph

"targueta" wrote in message
...
thanks I apreciate the help

"Ashish Mathur" wrote:

Hi,

Try this as the answer to the first question

TEXT(MID(A1,1,FIND(".",A1,1)-1)&":"&MID(A1,FIND(".",A1,1)+1,10),"[hh]:mm")

"targueta" wrote in message
...
I need help with a couple of issues in the same table.
-the first one is: how to convert numbers to time; right now I have
a cell
that gives me 0.84 and I need to covert this to hours: minutes (what
should
be 0:48)
-the second one is: I need to multiply the previous time (0:48) by a
Quantity (example: 320) and get the result in hours: minutes (what
should
be
256:00)
Can any one help? Thanks in advance