Complicated Time Formula
I think you'll find the formula works if you copy the formula to D2, not C2
as he suggested.
"Jay" wrote in message
...
I have it set up exactly as you describe and it still
comes up one hour off. Any Idea on how to have it
function with time period that pass through midnight.
Thank You again
Jay
-----Original Message-----
Hi Jay!
We are obviously set up a little different because mine
is coming up
OK.
A2 Start Time
B2 End Time
C1 8:00
D1 =C1+1/24
Copied across
Formula is in C2 copied across.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax
and Arguments)
available free to good homes.
wrote in message
...
Norman,
Thank you very much. This was the type of solution I
was
hoping for, as I am not very finiliar with VBA. The
formula you suggested functions well, however it
results
are placed into the wrong cell. They are off by one
hour.
I.E.
A2 Start time 12:15
B2 End Time 12:30
In the 11:00 Column 15 comes up.
Thank you Very Much
.
|