Skip to Content
avatar image
Former Member

Decimal to Time

Hi,

Can somebody help in converting Decimal to time?

e.g. : 8.5 = 8:30

Many thanks,

Dharmi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 10, 2008 at 10:22 AM

    Hi Dharmi,

    It's a little bit complicated but here it is:

    =REPLACE(NSTR(FLOOR(@NUM1),".0"),".","")&":"&REPLACE(NSTR(((@NUM1-FLOOR(@NUM1))*60),".0"),".","")

    Regards,

    Natty

    Add comment
    10|10000 characters needed characters exceeded