Hi,

I'm sorry i didn't see your post here but did get your private message and responded. For the benefit of others, here is what I wrote:

Hi Mikey!

Thanks for writing. When you have a time elapsed that spans dates, simply subtracting the time is not enough as there are days between them that account for hours. If you are always going to have less than 24 hours total elapsed time, you can do a simpler calculation of this:

Field 1 Start Time

Field 2 End Time

Field 3 Elapsed Time (Calc) = End Time - Start time

Field 4 Adjusted Time (Calc) = Field 3 + 86400

Field 4 Conditional - if Field 3 is less than 0, output is Field 4, else output is Field 3

What this does is account for the number of seconds in a day (86400) and add that if the result is negative.

Now if you have the possibility of spanning multiple days and more than 24 hours, you can't use this trick! Here's how you'd do it instead:

Field 1: Start Date

Field 2: Start Time

Field 3: End Date

Field 4: End Time

Field 5: Days elapsed (Calc, output as Integer) = End Date - Start Date ---> Here we are subtracting to see how many days have passed

Field 6: Seconds for Days (calc, output as integer) = (Field 5 - 1 )* 86400 ---> Here we are converting the above to seconds so it can be used with the time. Subtracting one since if the difference between a time one day and a time the next day is not 24 hours + the time, but just the time differences accounted for below. (Make sure to use parenthesis when setting up the formula.

Field 7: Time to End 1st (calc, output as integer) 86400 - Start Time --> This is the number of hours from the start time to the end of that first day.

Field 8: Total Elapsed Time (calc, output as time) Field 6 + Field 7 + Field 4 --> The trickiest part to understand here. This is adding the time until the end of the first day (field 7) plus the elapsed seconds for the days that spanned between them (field 6) plus the number of seconds into the last day (the end time, field 4).

Field 9: In Hours (calc, output to 4 decimal places) Field 8 / 3600 --> The above was shown as a time which may be confusing when it's more than 24 hours, so this one calculates the total number of hours elapsed for billing type purposes.

I have created a sample database demonstrating this and uploaded this to the HanDBase Gallery for you to look at if need be. Here's the link:

http://www.ddhsoftware.com/gallery.html ... ecord=4774To answer your second question, yes, if you have more than 5 operands in a calculation you can create a chain of calculations to compensate for that limit. For example, if you were adding fields 1-7 together, you could do:

Field 8: Sub 1 (Calc) = FIeld 1+ Field 2+Field3+Field 4+ Field 5

Field 9: Total (Calc) = Sub1 + Field 6 + Field 7

And you could then hide field 8 from view!

I hope this helps!