Results 1 to 9 of 9

to calculate credit days based on time slabs

Threaded View

  1. 01-11-2019, 03:44 AM #1
    Vivek2705
    Vivek2705 is offline
    Forum Contributor
    Join Date
    02-13-2016
    Location
    MUMBAI
    MS-Off Ver
    Microsoft 365
    Posts
    180

    to calculate credit days based on time slabs

    hii.. attached here is query image..

    Kindly help me with the required formula.. I think mod function will work but how to use it with time is a bit tricky task for me..

    Thanks..
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
« 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. [SOLVED] How to get sum of overdue payment based of given credit days period
    By devawad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-18-2018, 02:16 AM
  2. [SOLVED] calculate total number of days between two days based on 365 days year
    By aparunkumar in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-14-2016, 12:51 AM
  3. Calculate time same day and multiple days
    By effendrew in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-30-2015, 01:52 PM
  4. How to calculate number of sick days taken in a rolling 365 days period based on colour
    By shazzm in forum Excel General
    Replies: 0
    Last Post: 06-11-2015, 03:12 AM
  5. [SOLVED] If Conditions to calculate slabs - URGENT
    By manojsamuel2003 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-14-2015, 06:31 AM
  6. Add to total credit by 30, 60, 90 days
    By ianmb in forum Excel General
    Replies: 7
    Last Post: 01-18-2011, 11:53 AM
  7. Calculation of tax based on tax slabs
    By vikesh in forum Excel General
    Replies: 5
    Last Post: 01-15-2005, 01:11 AM

Tags for this Thread

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