working out minutes between times

[rich_cirillo]

How can i calculate how many minutes between dates & times. These dates and times can be in the same day or they can spread over multiple days

Example: 1st entered date/time is in cell B4 (22/11/2017 7:34:00 am) & 2nd entered date/time is in cell B5 (23/11/2017 10:34). The formula or VBA would work out the difference in minutes from these 2 dates and times.
Time is in 24 hrs periods

Cheers
RC


[TABLE="width: 179"]
<tbody>[TR]
[TD="class: xl63, width: 179"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[barry houdini]

If you get the difference and multiply by 1440 that will give you the total minutes difference (1440 is the number of minutes in a day), e.g. in B6

=(B5-B4)*1440

Format B6 as general or number

 

[bellman101]

Hi RC,

What about =(B5-B4)*1440

Cheers
JB

 

[bellman101]

^ What he said! ^

 

[rich_cirillo]

Thanks to both of you.Appreciated