How to sum a column of hours & minutes in format TEXT(C5-B5,"h:mm"

[Guest]

I have tried various formats but cannot sum the following:-

B5=12:00:00 C5=14:00:00 D5=TEXT(C5-B5,"h:mm")=2:00
B6=18:19:20 C6=19:19:20 D6=TEXT(C6-B6,"h:mm")=1:00
B7=03:00:00 C7=21:00:00 D7=TEXT(C7-B7,"h:mm")=18:00
.. TOTAL D8=21:00 but what is the formula to
Sum D57?

Thanks, Nosam (OldGiraffe).

 

[Bob Phillips]

Hi Nosam,

Why do you use Text for D5?

It would be easier if you just used -C5-B5, and formatted the cell as hh:mm.
The sum would work fine then, just format the sum cell as [hh]:mm to cater
for more than 24 hours.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Many thanks.

I do not know how I went down the TEXT path which caused complications!

Nosam.

Hi Nosam,

Why do you use Text for D5?

It would be easier if you just used -C5-B5, and formatted the cell as hh:mm.
The sum would work fine then, just format the sum cell as [hh]:mm to cater
for more than 24 hours.

--

HTH

RP
(remove nothere from the email address if mailing direct)

I have tried various formats but cannot sum the following:-

B5=12:00:00 C5=14:00:00 D5=TEXT(C5-B5,"h:mm")=2:00
B6=18:19:20 C6=19:19:20 D6=TEXT(C6-B6,"h:mm")=1:00
B7=03:00:00 C7=21:00:00 D7=TEXT(C7-B7,"h:mm")=18:00
. TOTAL D8=21:00 but what is the formula to
Sum D57?

Thanks, Nosam (OldGiraffe).