I need help with a simple formula
I am trying to do a sum of a row of 8 cells (O5:V5) that contain hours and
minutes. If the sum is less than 24hrs it displays okay, if the sum comes to
more than 24hrs (ie 27hrs) then it only shows 03:00hrs as the total. All cell
formats have been set to the "Time" format. Can anyone help me please?
|