I have 2 columns in excel, each column includes a date and a time in the following format: 'dd/mm/yyyy hh:mm'. One is a start date/time, the other is an end date/time. The end date/time could be another day for example. Time is in 24hr clock.
Sample data: 18/12/2012 16:13 | 19/12/2012 01:21
Can anyone help with a formula which can look at each of these columns and produce a total minutes duration between the start time and end time.
I have tried a few already, but having the date in there as well is where I get stuck.
Thank you in advance!