Computer Related > excel date/time formatting query Miscellaneous
Thread Author: borasport Replies: 6

 excel date/time formatting query - borasport
I have an excel spreadsheet where columns A,B, are both in date time format and column C is B-A.
Column C is displayed as the ddd.dd i.e. number of days as a decimal - is there any way I can format it as either hours and minutes or days,hours and minutes ?
everything I try seems to generate output that is plainly wrong - i.e. 133.0597 (days) displays as 12:01 hours in hh:mm format and 12:01:26 in dd:hh:mm format
any ideas ?
 Messages Author Date
 excel date/time formatting query new borasport 16 Mar 10 08:49
 excel date/time formatting query new spamcan61 16 Mar 10 11:03
 excel date/time formatting query new civic_duty 16 Mar 10 11:14
 excel date/time formatting query new borasport 16 Mar 10 11:25
 excel date/time formatting query new civic_duty 16 Mar 10 11:31
 excel date/time formatting query new borasport 16 Mar 10 11:50
 excel date/time formatting query new John H 16 Mar 10 21:01
Latest Forum Posts