T Tarheel8181 New Member Feb 2, 2015 #1 See attached. Looking for formula to sum total number of hours that span days and display total as "XX hrs" in yellow highlighted cell. Attachments Excel Question 3.xlsx Excel Question 3.xlsx 8.2 KB · Views: 3
See attached. Looking for formula to sum total number of hours that span days and display total as "XX hrs" in yellow highlighted cell.
Luke M Excel Ninja Staff member Feb 2, 2015 #2 You can either use a number format of: [hh] to get the 30, with a regular SUM function. Or, you could do: =SUM(B2:B4)*24 to convert the hours, and use a regular number format.
You can either use a number format of: [hh] to get the 30, with a regular SUM function. Or, you could do: =SUM(B2:B4)*24 to convert the hours, and use a regular number format.
