Hi,
I have a column for scheduled date/time of an exam, and another column for actual date/time the exam was performed. I need a formula to find the difference in minutes between the two columns.
Exam Date/Time Scheduled Date/Time
11:12:49 AM 11:00:00 AM
8:56:43 AM 9:00:00 AM
10:51:08 AM 10:30:00 AM
10:43:20 AM 11:00:00 AM
3:07:50 PM 3:00:00 PM
10:27:38 AM 10:30:00 AM
Please help, thanks!
Try this...
=VALUE(TEXT(MAX(A1:B1)-MIN(A1:B1),"[m]"))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi,
for difference between two date/time values in minutes:
Formula:
Please Login or Register to view this content.
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
Thank You!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks