rich_cirillo
Board Regular
- Joined
- Sep 26, 2012
- Messages
- 247
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
<tbody>
</tbody>
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
<tbody>
</tbody>