Search results for query: *

Mike, getting some unusual results. My report returns 53 results. 28 of these have the start down date/time and resultant fixed date/time within the same working day and therefore return the correct value. 1 of these has a large value downtime of 28 hours 45 minutes and and calculates a fixed...

Mike, the closest I can get is your last formula. When the log date and fix time are within the same working day (9am to 11pm) the calculations are fine. When the resolution is the following working day (Monday to Sunday) it seems to lose 10 hours and put it before the working day start time...

You are correct Mike, my original request was for a specific time window but I have now come across another that needs to be managed by a variation of your original formula. This particular example that I have mentioned has a service coverage of 9am to 11pm 7 days per week so if the log...

Mike Found an example where this doesn't work and cannot figure it out, wonder if you can. I have the following formula which works in most cases. local datetimevar startdown; local datetimevar uptime1; local datetimevar uto; local numbervar daysadd:=truncate({SCCall.Call_DTime}/8); local...

Thanks Mike, works like a dream. As you can tell I am new to Crystal, have managed to do ok so far but just got stumped with this one. Your help is greatly appreciated.

Thanks Mike, I have added that in and am still getting a couple of errors. My formula is now: local datetimevar startdown; local datetimevar uptime1; local datetimevar uto; local numbervar daysadd:=truncate({SCCall.Call_InDate}/8); local numbervar down:={SCCall.Call_InDate} - (daysadd * 8)...

Sorry for not putting more info in. I am using Crystal 8.0 running from an SQL database. Example data is as follows. Call in date = 01-09-04 13:27 Downtime = 18.55 (works out to 66780 seconds/18hrs 33mins) I would expect a result, based upon a 9 to 5 window off approximately 03-09-04 16:00. Just...

HELP !!!! I am trying to create a formula but am struggling and hope someone can help me. I basically have a start date/time and a downtime where the downtime is the amount of hours (in decimal format) that the problem has been unresolved, this is often different to the close date/time. I need...