Good afternoon, I've created a spreadsheet yesterday to keep track on working hours of our personnel and such. As there are nightshifts to be done, it's also needed to calculate over night, which I managed to get working. Now I want to sum up all the total hours and it results in extreme high values. This due to the 'general' outcome being at around 22 when it's an overnight calculation. The general value of 22 will be multiplied by 24 by Excel and result in a high total times. Is there any way I can just sum up the results given by the time format [h]:mm;@? Or does it always calculate on the general format? Thank you!
Solved by C. C. in 18 mins