How to get Excel to SUM 7am Monday to 7am Tuesday?

[Ronspeed9]

Hi folks! I'm new to the forum and need your help. I have reviewed prior 'Posts" and have not found one that matched my needs. I discovered the formula (=J9+(C9>J9)-C9) for SUM of 5:30 am to 3:30 pm, same day. But what is the formula for 7am today to 7am tomorrow. I know the answer but I don't know how to tell Excell. See below date 2/3/2013:

EXTRACTED FROM EXCEL
DATE DAY CLOCK-IN DATE DAY CLOCK-OUT Total Hrs
2/1/2013 Fri 7:00:00 AM 2/1/2013 Fri 5:30:00 PM 10:30
2/1/2013 Fri 5:30:00 PM 2/1/2013 Fri 10:00:00 PM 4:30
2/3/2013 Wed 7:00:00 AM 2/4/2013 Wed 7:00:00 AM 0:00 ??

ronspeed

[daddylonglegs]

You should use the dates - if clock in date is in A9, clock in time in C9, clock out date in H9 and clock out time in J9 then use this formula

=J9+H9-C9-A9

format result cell as [h]:mm

[Ronspeed9]

Sorry but that didn't work. It read 0:00.

=J10(7:00:00 AM)+H10 (2/4/2013) -C10(7:00:00 AM)-A10(2/3/2013) = 0:00 !!!!

[Ronspeed9]

Wait! It did work. My stupid fault. Needed brackets around "h". Thanks so much.