Sum of hours and minutes (> 24 hrs)

**sarah1531** · 01-03-2010, 02:55 PM

I have an Excel 2007 spreadsheet with a column containing time (formatted in hours and minutes). I can total the time where the answer is less than 24 hours, but can't get this to work when the total is greater than 24 hours. Can anyone help ? thanks!

**ConneXionLost** · 01-03-2010, 03:05 PM

Hi sarah1531,

Welcome to the forum!

For going beyond 24 hours you use the square brackets:

Elapsed time in hours; for example, 25.02 [h]:mm

Cheers,

**sarah1531** · 01-03-2010, 03:53 PM

Many thanks for reply, and sorry to be slow, but I'm not sure how to format as you suggest. I've attached a s/sheet just to illustrate my problem.

many thanks!