Adding hours slept when crossing midnight....

  • Thread starter Thread starter ZZZupan
  • Start date Start date
Z

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?
 
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)
 
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.
 
Back
Top