Time Formats

[rj]

Hi,

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

Thanx in advance..

 

[edessary]

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

 

[Guest]

=2.5/24 and format the result cell like time!


"150:00" looks like a real XL time format [m]:ss
Re-format it like h:mm:ss

Regards,
Stefi



„rj†ezt írta:

 

[rj]

thanx