Calculate Date and time difference

[carlrubber]

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	3/11/2016	20: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

<tbody>
</tbody>

I would like to use formula for calculate the time difference in minutes, would anyone help me please?? For example in the last row: the difference in minutes = 57mins

 

[AliGW]

What time difference???

 

[carlrubber]

looking for the time diff between Earliest date and time minu admission date and time in mins please

 

[AliGW]

So effectively columns C&D minus A&B in minutes - yes? What's your expected outcome for the first entry above, please?

 

[carlrubber]

ur suggestion can only show in time format, but let say the first row, I would like to show 1359 mins rather than 22:39

 

[AliGW]

Try this set:

=HOUR((C1+D1)-(A1+B1))*60+MINUTE((C1+D1)-(A1+B1))

Format to general.

 

[Tetra201]

Is this what you need?

=(C2+D2-A2-B2)*24*60

 

[carlrubber]

thz i got it

 

[AliGW]

In future, if you cross post, please say that you have done so.

 

[Joe4]

Cross-posted: Date and time difference calculation

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule #13 here: http://www.mrexcel.com/forum/showthread.php?t=99490).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: Excelguru Help Site - A message to forum cross posters).