Excel Formula minutes convert to hours

Wayne Paul wrote:
Using the format Category of "Time" and the Type "37:20:55" I entered 12:22,
14:38, 72:14 and the above mentioned 45:36. Summing this column gave an
accurate total of 144:50:00.

What version of Excel are you using?

I tried this in Excel 97 (I'm too cheap to upgrade). The key seems to
be using the "37:30:55" time format in the Format Cells dialog. If any
other time format is used, the values are interpreted as time of day,
and wrap around at 24 hours.

Marc

"Marc Ramsey" wrote in message
. com...
Wayne Paul wrote:
Using the format Category of "Time" and the Type "37:20:55" I entered
12:22,
14:38, 72:14 and the above mentioned 45:36. Summing this column gave an
accurate total of 144:50:00.

What version of Excel are you using?

I tried this in Excel 97 (I'm too cheap to upgrade). The key seems to be
using the "37:30:55" time format in the Format Cells dialog. If any other
time format is used, the values are interpreted as time of day, and wrap
around at 24 hours.

Marc

I'm on excel 2003 and the 37:30:55 time format aint available to me.

Peter.

Peter Seddon wrote:
"Marc Ramsey" wrote in message
I tried this in Excel 97 (I'm too cheap to upgrade). The key seems to be
using the "37:30:55" time format in the Format Cells dialog. If any other
time format is used, the values are interpreted as time of day, and wrap
around at 24 hours.

Marc

I'm on excel 2003 and the 37:30:55 time format aint available to me.

It is 99.9% likely that there is an equivalent in Excel 2003, as
Microsoft never takes code out, they just add new features that nobody
uses 8^). There are probably at least three distinct hh:mm:ss entries
in the format dialog, one should work.

Marc