I have an example on my website which handles many scenarios (including
spans over midnight)
Hours affected by dates

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"john86" wrote in message
...
i I am working on a spreadsheet, where I need to know how to Calculate
between two time formats, i.e. I want the cell to calculate between 06:00
and
18:00 and 18:00 and 06:00. If some one starts work at say 17:00 and
finished
at 07:00 the following day, I need it to tell me how may hours before
18:00,
then how many hours between 18:00 and 06:00, the how many hours after
06:00.
If some one could help.

Thanks John