• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 503
  • Last Modified:

subtract date and time display how many minutes difference

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

-Brandon
0
KnutsonBM
Asked:
KnutsonBM
1 Solution
 
zorvek (Kevin Jones)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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now