I don't really know what you're trying to achieve with the formula but for years I've been trying to get a formula to add up my hours so I can have a home made electronic logbook.
Last week I finally discovered the easy way to add times together and display a total that is greater than 24hours.
The problem is that when you have a column of times and add it to another column of times the answer will always try to show you a time i.e. upto 2400.
the simple solution is to change the format of the cells in the result column from hh:mm to [h]:mm hey presto no limit on the number of hours.
couldn't believe how simple it was yet it isn;t mentioned in any of the online help I searched.
[ 13 August 2001: Message edited by: Gash Handlin ]