Adding hours for split shifts

Originally Posted by Paul

As mentioned in a previous, although now missing, post, you could also use

=HOUR(A1)

where A1 holds the total time in hh:mm format.

=HOUR(A1) where A1 = 10:00 would result in just 10.

That was me.. but I deleted it realizing that there could be fractions of hours too..as you showed in your example, Paul.. Hour() only gives the hour portion and MINUTE() and SECOND() only give the minutes and seconds, respectively, as whole numbers