How to convert decimal to DMS in excel?

[nabinprd1]

How to convert decimal value calculated by formulas or function in excel to DMS with accurate result?
--
for example
--
Cell A1 is =86.25-83.45
Cell B1 is =TEXT(IF(A1=0,0,(A1/ABS(A1))*INT(ABS(A1))),"00°")&TEXT(INT(MOD((ABS(A1)*60),60)),"00'")&TEXT(MOD((ABS(A1)*3600),60),"00''")
--
The result is 02°47'00''
--
--
If we input 2.8 directly to the cell A1 then the result is 02°48'00''
--

[Phuocam]

Try:

=IF(A1<0,"-","")&TEXT(ABS(A1)/24,"[h]\°mm\'ss\''")

[nabinprd1]

Very very thanks, working with accurate result.