ExcelBanter - How do I add hours and minutes without 24 hour limit

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I add hours and minutes without 24 hour limit (https://www.excelbanter.com/excel-worksheet-functions/174445-how-do-i-add-hours-minutes-without-24-hour-limit.html)

Cycling Steven

How do I add hours and minutes without 24 hour limit

I need to add a column of process times. When I do the answer only shows
residual hours after muliples of 24. Is there a way of showing total hours
over 24?

Mike H

How do I add hours and minutes without 24 hour limit

Hi,

A custom format of [hh]:mm should do it

Mike

"Cycling Steven" wrote:

I need to add a column of process times. When I do the answer only shows
residual hours after muliples of 24. Is there a way of showing total hours
over 24?

All times are GMT +1. The time now is 07:03 PM.