subtract date and time display how many minutes difference

How can i subtract two dates and times and display the difference in Minutes?

-Brandon
LVL 6
KnutsonBMAsked:
Who is Participating?
 
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:
Total minutes between two date/time values:

   =(B1-A1)*1440

Kevin
0
 
barry houdiniCommented:
If you have a date/time in A2 and a later one in B2 just subtract, i.e.
=B2-A2
You can now use formatting to display the difference as required, e.g. custom format as [h]:mm to show the difference in hours and minutes, so 2 ½ hours will display as 2:30. If you want to see just minutes, i.e. 150 then custom format as [m]
regards, barry
0
 
KnutsonBMAuthor Commented:
exactly what i was looking for, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.