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.