Calculating 30 hours in a day.

[Jag108]

I work for a broadcasting company, if any one who works in broadcasting will
know, quite often they work to a 30 hour schedule.

My question is. I would like to caclulate the differences between start
time duration and the next start time, to make sure there are no overlaps or
gaps.

So for instance if an event has a start time of 25:30 and a duration of
00:30 then the next event should start at 26:00.

I am trying to use VBS to run over the schedule to indicate where there may
be errors.
A formula will be of no use because the file will then be imported into
another application, and so can not be changed in any way what so ever.
Because the importing program is looking for specific data, if it does not
find what it is looking for it will fail, so double trouble.

No adjustments in the file format/structure and no wrong start
times/durations.

Help

[Stefi]

What about conditional formatting? Assume that start times are in column B,
durations in column C, then select cells from B2 to Basyouneed, and apply in
Formatting/Conditional formatting dialog Cell value less then =B1+C1 and a
pattern (say red background).

Regards,
Stefi




„Jag108” ezt Ã*rta:

> I work for a broadcasting company, if any one who works in broadcasting will
> know, quite often they work to a 30 hour schedule.
>
> My question is. I would like to caclulate the differences between start
> time duration and the next start time, to make sure there are no overlaps or
> gaps.
>
> So for instance if an event has a start time of 25:30 and a duration of
> 00:30 then the next event should start at 26:00.
>
> I am trying to use VBS to run over the schedule to indicate where there may
> be errors.
> A formula will be of no use because the file will then be imported into
> another application, and so can not be changed in any way what so ever.
> Because the importing program is looking for specific data, if it does not
> find what it is looking for it will fail, so double trouble.
>
> No adjustments in the file format/structure and no wrong start
> times/durations.
>
> Help
>