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
|