2 Replies Latest reply: May 11, 2012 6:59 PM by swuehl RSS

Elapsed Time by Day, Across Multiple Days

Sam Chambers

I have a simple data set that looks like this:

 

(Sorry, but the "Insert Table" function isn't working for me.)

 

AccountNumber   StartDateTime     EndDateTime

A123456         1/1/2012 16:00   1/1/2012 18:25

A123457         1/1/2012 16:00   1/2/2012 08:15

A123458         1/1/2012 16:00    1/3/2012 14:45

 

I need to be able to calculate the number of hours for each day.  In this example, the daily totals would be:

 

1/1/2012 = 18.42 hours

1/2/2012 = 32.25 hours

1/3/2012 = 14.75 hours

 

I'm sure I'm not the first one to encounter this type of issue.  Would this be done in the script, in the expression, or a combination of the two?

 

Thanks.