|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 26th, 2009, 08:14 PM
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
March 26th, 2009, 08:44 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
