Hi
In an Excel sheet from Q8:Q20 i have entered many timings ( like 9:15 AM, 11:45 AM, 3:00 PM, 5:00 PM, 7:15 PM, etc ) in many cells. Now can we have a formula where it calculates the minimum Time and the maximum time and then show the total minutes between between them.
Like from the above example the minumum Time was 9:15 AM and Max was 7:15 PM and it should show how many minutes was there between two timings.
Faisal
This should work...
to determine the max
Please Login or Register to view this content.
to determine the minPlease Login or Register to view this content.
and then
to determine the # of minutes between...note you will need to change the cell format to [h]:mmPlease Login or Register to view this content.
=MIN(Q8:Q20)
=MAX(Q8:Q20)
=MAX(Q8:Q20)-MIN(Q8:Q20)
Format cells as [mm]:ss
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Ya it worked, but there is a small hiccup.
The Time break normally is from 12 AM to 11:59 PM. It calculates min and max in between this. But what i want is the Minimum Time should be 12 PM and Maximum Time will be 11:59 AM.
Most of our production happens between 4 PM and 5 AM in the morning. SO i want to calculate the Production hours between these time. So with the above formula if we give then the minimum time is the time entered after 12:00 Am. and this is not solving my problem.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks