I am trying to set up a spreadsheet and eventually a macro that wil
work out probable times of the day when an event occurred i.e. aoristi
analysis- based on two date fields and two time fields. For example:
Datefrom: 01/04/04
Timefrom: 13:00
Dateto: 03/04/04
Timeto: 21:05

refer to link below.
http://www.crimereduction.gov.uk/toolkits/fa020404.htm

A tool has been developed for a GIS application but i would like t
know how this could be done in excel especially when there may b
several hundred records with times/dates

--
Message posted from http://www.ExcelForum.com