| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Working out difference between 2 shown dates
I currently have a column which contains a date and time data
(20/06/2008 16:30) time / date occured and a second column containing similar data (24/06/2008 15:25) time/date reported. I would like to have a third column showing the difference in either hours/mins or mins between the time/date an incident occured and the time/date the incident was reported.Is there a formula i could use? Can anyone help? Thanks in advance |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Working out difference between 2 shown dates
Just subtract the two cells and custom format the results as
[h]:mm or just [mm] -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Deltic" wrote: I currently have a column which contains a date and time data (20/06/2008 16:30) time / date occured and a second column containing similar data (24/06/2008 15:25) time/date reported. I would like to have a third column showing the difference in either hours/mins or mins between the time/date an incident occured and the time/date the incident was reported.Is there a formula i could use? Can anyone help? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Charting only the dates shown | Charts and Charting in Excel | |||
| Convert 29.08 hours (shown in decimal form) to time shown in "hh:m | Excel Worksheet Functions | |||
| Column of Text Shown = Total Times Shown? | Excel Worksheet Functions | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) | |||
Hybrid Mode
