on 11-10-2008 9:58 AM
Hi,
Can somebody help in converting Decimal to time?
e.g. : 8.5 = 8:30
Many thanks,
Dharmi
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.