+ Reply to Thread
Results 1 to 2 of 2

How to calculate the no. on minutes falling in each month between two days

  1. 03-26-2016, 06:50 AM #1
    Nitinkumar
    Nitinkumar is offline
    Registered User
    Join Date
    04-05-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    59

    How to calculate the no. on minutes falling in each month between two days

    Hello Sirs,


    Seeking your precious support in calculating the no. on minutes falling in each month between those two days. I have attached a sample excel. Request please help.


    Nitin
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-26-2016, 07:16 AM #2
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,037

    Re: How to calculate the no. on minutes falling in each month between two days

    Change month names into numbers and use:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Just June has 30 days, not 31. You have one extra day.
    Attached Files Attached Files
    Never use Merged Cells in Excel
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to calculate end of month -2 days
    By joao1232 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2016, 08:49 AM
  2. Calculate Days, Hours & Minutes Worked
    By Mulderman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2015, 09:15 PM
  3. Need help to know a forumla to calculate number of days falling in a year from a contract
    By Assadniazi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-16-2015, 05:34 AM
  4. Calculate minutes per month from two different date & time values in different months
    By jasleen0302 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-22-2013, 08:04 AM
  5. Adding days hours and minutes to calculate time of end of auction?
    By yenom2 in forum Excel General
    Replies: 6
    Last Post: 12-01-2012, 05:28 PM
  6. How do I calculate the number of days hours minutes and seconds between 2 date & time
    By LAB_RAT in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2011, 06:50 PM
  7. How do I calculate the number of days hours minutes and seconds between 2 date & time
    By LAB_RAT in forum Excel General
    Replies: 1
    Last Post: 11-02-2011, 06:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1