How do I summarize total hours over multiple days
 

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.

How do I summarize total hours over multiple days
 

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

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"DavidT" wrote in message
...
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.

How do I summarize total hours over multiple days
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"DavidT" wrote in message
...
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.

How do I summarize total hours over multiple days
 

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.

"Bernard Liengme" wrote:

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

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"DavidT" wrote in message
...
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.

How do I summarize total hours over multiple days
 

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.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"DavidT" wrote in message
...
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.

How do I summarize total hours over multiple days
 

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.
--
Thanks,
Shane Devenshire


"DavidT" wrote:

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.

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"DavidT" wrote in message
...
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.