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