Adding hours slept when crossing midnight....

[ZZZupan]

=TIME(23,30,0) =TIME(8,0,0) =SUM(C1-B1)
h:mm AM/PM h:mm AM/PM h:mm

Can someone help me add this correctly?

 

[Chip Pearson]

Try something like

=B1-A1+(B1<A1)

where B1 is the end time and A1 is the start time.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[Myrna Larson]

C1-B1 isn't the correct formula, as others have said.

I just want to point out that IF IT WERE CORRECT, you should write it as

=C1-B1

There's no reason for a SUM formula here. When you write it that way, Excel will subtract the
number in B1 from that in C1 to get a result. Then you pass that result on to SUM. Doing that
just wastes time. The sum of a single number is that number itself.