software

Hi,

I need to know how to change a value into a time format.
eg. i want to change quot;2.5quot; into quot;02:30:00quot; (hh:mm:ss)
is there a funtion in excel?
Or if i have the values like quot;150:00quot;, how can i convert it to
quot;02:30:00quot;?

Thanx in advance..If I understand your question correctly the following formula should
work if the hours and fraction of hours are in cell A1:

=INT(A1/24) TIME(INT(A1),MOD(A1,INT(A1))*60,0)

Set the format of the cell that contains this formula to [h]:mm:ss=2.5/24 and format the result cell like time!quot;150:00quot; looks like a real XL time format [m]:ss
Re-format it like h:mm:ss

Regards,
Stefi
?j??ezt ?rta:

gt; Hi,
gt;
gt; I need to know how to change a value into a time format.
gt; eg. i want to change quot;2.5quot; into quot;02:30:00quot; (hh:mm:ss)
gt; is there a funtion in excel?
gt; Or if i have the values like quot;150:00quot;, how can i convert it to
gt; quot;02:30:00quot;?
gt;
gt; Thanx in advance..
gt;
gt;

thanx