HELP adding numbers in HH:MM format to give a general total?

Hi

would be massively appreciated if someone could help me with this!

I need to add some HH:MM values to give a total general value, its for a staff rota, i need total values for the hours worked per day/week.

eg. three 8 hour days in 08:00 format to give a total of 24

is that possible??

Hi.

When calculating add it up as normal but you need to format the cell which will give the total from HH:MM to [HH:MM]. This will then give the results in actual time.

I hope this helps.

NIN3884.