6 Replies Latest reply on Oct 22, 2010 11:48 AM by philmodjunk

    Get Total Hours between Total Days, Time Start and Time End

    mysterious

      Title

      Get Total Hours between Total Days, Time Start and Time End

      Post

      Here are the example:

       

       Date Start : 8/24/2009

       Date End : 8/26/2009

       

       Total Days : 3

       

       Start Time :  7:45:00 AM

       End Time :   4:30:00 PM

       

      Gives result of 

      Total Hours : 24 hours 135 minutes 

       

      Below is the calculation:

       

      Total Hours = (Total Days) * Hour(Time End - Time Start) & (If (Hour (Time End - Time Start) = 1; " hour, "; " hours ")) & (Total Days) * Minute(Time End - Time Start) & (If (Minute (Time End - Time Start) = 1; " minute "; " minutes ")) 

       

      I can't figure out how to subtract the difference in hours and minutes.