Sometimes your data lives inside an excel spreadsheet...
=IF(X2<0,"-","")&FLOOR(ABS(X2)/$'Year Summary'.$H$20,1,1)&"d, "&FLOOR(MOD(ABS(X2),$'Year Summary'.$H$20),1,1)&":"&IF(FLOOR(MOD(ABS(X2),1)*60,1,1)<10,"0"&FLOOR(MOD(ABS(X2),1)*60,1,1),FLOOR(MOD(ABS(X2),1)*60,1,1))
1 comment:
oh yes, the excel days. i was an excel nut case before i got started programming with C.
Post a Comment