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

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 D5:D7?

Thanks, Nosam (OldGiraffe).

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)


"nosam" <nosam@discussions.microsoft.com> wrote in message
news:E25D20E7-1A5A-40C6-9937-4D326EDC19ED@microsoft.com...
> 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 D5:D7?
>
> Thanks, Nosam (OldGiraffe).

Many thanks.

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

Nosam.

"Bob Phillips" wrote:

> 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)
>
>
> "nosam" <nosam@discussions.microsoft.com> wrote in message
> news:E25D20E7-1A5A-40C6-9937-4D326EDC19ED@microsoft.com...
> > 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 D5:D7?
> >
> > Thanks, Nosam (OldGiraffe).
>
>
>