Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to calculate difference between dates and times
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to calculate difference between dates and times
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to calculate difference between dates and times
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<Space17:00 Same for exam in Column B: 2/26/06<Space11: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! ================================================== === "Breezie" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate duration between two dates and times in excel? | Excel Discussion (Misc queries) | |||
calculate elapsed time between dates and times | Excel Worksheet Functions | |||
Difference in dates calculations except between certain times. | Excel Discussion (Misc queries) | |||
Difference between 2 times and dates | Excel Worksheet Functions | |||
Formula to calculate elapsed time between certain dates and times | Excel Discussion (Misc queries) |