Looking for formula to calculate the time difference in minutes, would anyone help me please?
Admission Date (yyyy-mm-dd) Admission Time (HH:MM) Earliest Assignment Date (yyyy-mm-dd) Earliest Assignment Time (HH:MM)
1/11/2016 2:17 2/11/2016 0:56
2/11/2016 22:13 2/11/2016 22:25
4/11/2016 11:57 4/11/2016 14:09
31/10/2016 17:56 31/10/2016 18:47
4/11/2016 20:03 4/11/2016 20:15
2/11/2016 12:40 2/11/2016 12:50
3/11/2016 3:48 3/11/2016 4:00
5/11/2016 23:03 6/11/2016 0:00
For example in the last row: the difference in minutes = 57mins
https://www.mrexcel.com/forum/excel-...ml#post4741720
Bookmarks