How do I summarize total hours over multiple days

[DavidT]

EXCEL 2003- How can I modify
"=IF((OR(C10="",B7="")),0,IF((C10<B7),((C10-B7)*24)+24,(C10-B7)*24))" to add
up total hours over multiple days with a start time in one cell and end time
in another cell. And how do I link those cells to a date.

 

[Bernard Liengme]

Do the cell have data like:
A) 10:30 PM
or
B) 9/1/2008 3:30 PM

best wishes

 

[Bernard Liengme]

Let
A1 has date such a 9/1/2008 (US style)
A2 has time such as 3:30 PM
And this two values represent start time
B1 has date such as 9/3/2008
B2 has time such a 7:00 AM
And this two values represent end time

The =((B1+B2)-(A1+A2))*24 gives 39.5 when formatted General as 39 1/2 hours
have passed
best wishes

 

[DavidT]

I have one column with consecutive dates(ie.A1,A2,A3...), the next column
with a start time(ie.B1) adjacent to that date, the next column with the stop
time(ie.D3) adjacent to an ensuing date(ie.A3), and the next column for the
total hours from B1 to D3.

A B C D
Date Start Stop Total
1 1/1 10:00
2 1/2
3 1/3 8:00 from B1 to C3

What is needed is a formula to show total hours and minutes from start to
stop.

 

[DavidT]

That solution won't work as I need to have a running calender in a single
column and the ability to enter start time in one col. adj to one date and an
end time adj to an ensuing date with a solution in the next col. I need to
make multiple entries of start/stop times through the calender month.

 

[ShaneDevenshire]

Hi,

Assume your data starts in A1:C4 where row 1 contains titles then:

=A4+C4-A2-B2

Format this cell as Custom [hh]:mm

If this helps, please click the Yes button.