Adding time value in numbers
I would like to add units of time together in a column I do not want it to show days when over 24 ex: 250:36 would mean 250 hr 36 minutes
explanation 2hr 36m + 1hr 24m = 4h 0 m
I want this 2:36 + 1:24 = 4:00
Question marked as
Format the three cells as duration with custom units
Formula in B4 is =B2+B3
BUT... You cannot enter the values the way they are appearing in the cells in the screenshot. If you type 2:36 and hit Return it will take it as 2 minutes 36 seconds and show it as 0:03 (as in 2 minutes 36 seconds rounded to the nearest minute). If you type it as 2:36:0 or 2:36:00 or 2h36m, it will reformat it as 2:36.
If you want to add more than two durations, you might want to use the SUM function instead of a bunch of +'s