Time format problem

[thegooser123]

Hi all...

I have a columm representing time but formatted as a number like this 20.30 represents 8:30pm or 20:30.

20.50 is 8:50pm or 20:50. I can only find a formula that changes it from decimal to time but my 20.50 would turn into 20:30 as it changes it to twenty and a half.

Bassically, is there any way to change my numbers to time?

 

[shg]

20:30 is the desired result, is it not?

What's the formula you're using?

 

[GaryWMn]

Try this (assuming A1 contains your value):

=TIME(INT(A1),(A1-INT(A1))*100,0)

Let us know if this works for you.

Gary

 

[shg]

Or

=DOLLARDE(A1,60)/24

 

[thegooser123]

Try this (assuming A1 contains your value):

=TIME(INT(A1),(A1-INT(A1))*100,0)

Let us know if this works for you.

Gary

Thats the ticket

Thanks for all your help guys!!!!