How is the data entered? If the assault date/time is in B2 and the exam
date/time is in C2, the elapsed time, in hours is =24*(c2-b2). Format the
result as a decimal number. If the data is entered with dates and times in
different cells, the general formula would be =24*(exam time cell + exam date
cell - assualt time cell - assault date cell).
--Bruce

"Breezie" wrote:

I need to set up a spreadsheet where the nurses will be typing in the date
and time of an assault and the date and time of an exam. I need the
spreadsheet to calculate the amount of hours that have passed between the two
dates. So if the victim was assaulted on 02/24/06 at 9:00 PM and comes into
the hospital for an exam on 02/26/06 at 11:30 AM, I need to know how much
time in hours has passed between the day and time of the assault and the
examination. I am working on Excel 2000.
Thanks!