formula to calculate difference between dates and times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
The entry of the time and date and the formatting of the result (formula)
cell are the governing factors here.

It's probably easier to use a *single* cell for date and time entry, with 24
hour time format.

If Column A is assault date and time, enter in this fashion:
2/24/06<Space>17:00

Same for exam in Column B:
2/26/06<Space>11:30

Now, in Column C:
=B1-A1
And custom format to:
[h]mm

The square brackets prevent the hours greater then 24 from rolling over into
days.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number of hours between now and selected date 5
Calculating time between mulitple dates 4
Determine if night shift by start & end time 2
Calculating diff between date/ time only between certain hours 5
Calculate times between dates and times in Excel 1
sum columns between certain dates 1
Calculating diff between date/ time only between certain hours 4
Calculating difference between dates 3

Back
Top