Time difference in minutes only

Manolocs

Active Member
Joined
Mar 28, 2008
Messages
339
Hello, I need the result in column "B" as a minutes only.
The column "A" can have dates more than 10 days but still the results need to be in minutes.
Any help is more than welcome :)

ABC
27/Mar/18 09:00
27/Mar/18 11:00120

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,280
Office Version
  1. 365
Platform
  1. Windows
Try
=(A2-A1)*1440
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,336
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
Or possibly if you just want the result displayed
and custom format as [mm]
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,109,308
Messages
5,527,930
Members
409,793
Latest member
mavrik_stet

This Week's Hot Topics

Top