I have totalled up a number of hours of observations in
an excel sheet which comes to 10 days 16 hours 58 minutes
displayed as
10.70694444
but if I convert / format that to Hours, excel "loses" the days and
only displays the 16 hours 58 minutes as 16:58
I would really like to display both as 256:58
and as
10 days 16:58
Anyone any clue?
David Jobson
|