AnsweredAssumed Answered

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

Question asked by mysterious on Aug 31, 2009
Latest reply on Oct 22, 2010 by philmodjunk

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.

 

 

Outcomes