ExcelBanter - How do I sum hours and minutes totalling over 24 hours?

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

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

- - How do I sum hours and minutes totalling over 24 hours? (https://www.excelbanter.com/excel-worksheet-functions/90712-how-do-i-sum-hours-minutes-totalling-over-24-hours.html)

Henry

How do I sum hours and minutes totalling over 24 hours?

I am totalling hours and minutes for part-time staff in Excel. How can I get
excel to give actual total times where the total exceeds 24 hours?

How do I sum hours and minutes totalling over 24 hours?

Hi

Format the result as [hh]:mm

Andy.

"Henry" wrote in message
...
I am totalling hours and minutes for part-time staff in Excel. How can I
get
excel to give actual total times where the total exceeds 24 hours?

All times are GMT +1. The time now is 12:55 AM.