Newbie Questions

Re: Calculating Days and Time

Lockdown — Wed, 31 Aug 2011 20:45:11 GMT

You would most likely have to fiddle around with the formula for time, but I think that example will give you a general idea of how to get it done.

Re: Calculating Days and Time

kcark1 — Wed, 31 Aug 2011 20:39:49 GMT

That's exactly what I wanted! Thanks. Would the same basic function work for time?

Thanks again.

Re: Calculating Days and Time

dms.WebDev — Wed, 31 Aug 2011 19:20:00 GMT

thank you I was looking for just this functionality!

Re: Calculating Days and Time

Lockdown — Thu, 25 Aug 2011 16:32:42 GMT

I'm attaching a form with the idea from that blog.

Re: Calculating Days and Time

kcark1 — Thu, 25 Aug 2011 12:35:09 GMT

Thank for the link, unfortunately, I am not able to open. Any other help would be appreciated.

Re: Calculating Days and Time

Lockdown — Tue, 23 Aug 2011 23:40:19 GMT

Check out this site

http://alecpojidaev.wordpress.com/2008/12/30/infopath-codeless-programming-walkthrough-2/

Calculating Days and Time

kcark1 — Tue, 23 Aug 2011 13:13:12 GMT

I'm still very green with InfoPath but the more I use it the more I like it. Would like assistance on the following.

I am trying to calculate the number of calendar days based upon three fields "ServiceFromDate", "ServiceThruDate", and "TotalServiceDays". As an example, if the service from date is 08/01/11 and the service thru date is 08/07/11, I need the total service days field to reflect 7 days.

Alternatively, I need to calculate the duration of service provided to a client in a different portion of the form with the three fields "ServiceStartTime", "ServiceEndTime", and "TotalServiceTime". As an example, if the service start time is 10:00 and the service end time is 11:30, I need the total service time field to reflect 1.5 hours.

Any advise would be appreciated.