I am currently working with a data log with dates and times for work. We do ambulance dispatching and are attempting to determine what calls for service have another entry within two hours (IE: Ambulance is requested and there were 3 other calls for service in the past two hours) to determine when the system has potential to be overloaded.
I have times in "MM/DD/YYY HH:MM:SS" format in one column so I know there is probably a simple way to calculate this (either as a formula or a conditional formatting rule) but it is completely stumping me.
Any suggestions??
Bookmarks