### 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.

Timestamp ( EndDate ; EndTime ) - Timestamp ( StartDate ; StartTime )

From this you can easily extract the hours, minutes and seconds using the corresponding functions.