View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pendelfin
 
Posts: n/a
Default Working with times

I just wondered if it was possible to check time availavilty within a
spreadsheet.

For example. I have the following data
Date Start Time End Time
5/2/03 09.00 11.00
5/2/03 13.00 15.30
5/2/03 15.00 16.00

For the 3rd entry I would like to display an error as there is already a
meeting scheduled for this time.

I have asked this before, but maybe wasn't very clear in what I required, as
I had no responses. If there is no way to do this, many thanks for taking
the time to read this post. If there is possbly another way I could work
this please let me know, any help would be greatly appreciated.

Many Thanks