Code

Re: Time Calculations

Matt Faus — Tue, 20 Feb 2007 14:30:38 GMT

DuneBug is exactly right on this one. You will want to do something like this:


DateTime startTime = DateTime.Parse( stringValueOfStartTimeField );
DateTime endTime = DateTime.Parse( stringValueOfEndTimeField );

TimeSpan duration = endTime.Subtract( startTime );
string output = duration.Hours + ":" + duration.Minutes; // Assumes < 24 hours, also probably want to add zero padding
// same thing for mttr

This has been discussed several times on the forum so you might want to do a quick search if you run into trouble.

Re: Time Calculations

DuneBug — Fri, 16 Feb 2007 20:19:14 GMT

you may've already thought of this, and i'm not sure what environment you're using, but do you know about the system.Datetime object?

As long as you're working with Microsoft I'd think you'd have it available to you. Here's a link with some documentation on it.

If you have to do math with dates and times using a pre-made object is the only way to do it.

http://msdn2.microsoft.com/en-us/library/system.datetime.aspx

Re: Time Calculations

snyderjd — Thu, 25 Jan 2007 20:05:49 GMT

Thank you, this does work, but only if dealing with time whick limits me to a 24 hour period. I need to be able to calculate date and time... some times start on one day but end on the next day...

Re: Time Calculations

Shilpa Pitta — Wed, 24 Jan 2007 08:06:51 GMT

Hi
Check this link,Hope this helps you!
http://enterprise-solutions.swits.net/infopath2003/article.php?t=time-calculations-using-rules&c=infopath2003

And for your second question, You want to enter the date and time manually or by using the date picker?

Time Calculations

snyderjd — Tue, 23 Jan 2007 22:51:06 GMT

OK, I have been searching high an low to figure out a way to do this without using managed code. I think the only way to this is with scripting or coding. I think I would prefer to use jscript if possible... as i hae some other jscript in place already...

I have 5 fields: StartTime, ReportTime, EndTime, OutageDuration, & MTTR (Mean Time To Repair)

What I need to do is end up with two values. Outage Duration needs to be HH:MM = EndTime - StartTime and MTTR needs to be (EndTime - ReportedTime) in minutes/60.

I need to have the Start Time and Report Time and End Time be in mm/dd/yy hh/mm format ...

any ideas. I have been looking high an low. I have not had very much luck.