Calculate difference in hours of actual day/time data versus fixed weekdays

[Shawn]

Hi,

I am faced with a problem of performing calculations on dates and
weekdays.

I have a planned schedule of events that occur regularly on a
particular day of the week. (e.g every Wed 02:00). I am currently
performing an analysis based on realtime data with the following
format "Thu 1/15/2004 17:00" (ddd mm/dd/yyyy hh:mm). I need to
calculate by how many hours the event is early or late. See below for
an illustration:


Event | Planned Time | Instance 1 of event |
| |Actual Difference|
-----------------------------------------------------
A Wed 12:00 Thu 1/15/2004 17:00 29

B Sun 03:00 Sat 1/24/2004 23:59 -3.016

From the actual time data i need find out how many hours the event
occurs late/early. The size of the data is huge (some thousands), but
i cannot figure out a formula for this.

Thanks.


Shawn

 

[Bob Phillips]

Shawn,

Just subtract the earlier from the later, but ensure you format the result
as [h]:mm.

If you want decimal hours, multiply by 24 and format as General.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Arvi Laanemets]

Hi

For cell C2 the formula is
=(C2-B2)*24
formatted as Number with 3 digits