
1. Re: I want to add minutes to hh:mm field & calculate a new hh:mm result. Here's an example: add 90 minutes to 7:00. Result = 8:30. How do I do this? Thanks.
Robin Kennedy Sep 10, 2012 10:36 AM (in response to Renelle Risley)Dates and times are stored as whole numbers and decimals respectively (i.e. 6 hours is 0.25 of a day) so to add your expected run time which is specified in minutes, first divide it by 1440 (number of minutes in a day) and then add it to your date dimension.
Hope that helps.

2. Re: I want to add minutes to hh:mm field & calculate a new hh:mm result. Here's an example: add 90 minutes to 7:00. Result = 8:30. How do I do this? Thanks.
Andrew Watson Sep 10, 2012 2:59 PM (in response to Renelle Risley)What about DATEADD('minute',[Expected Procedure Length], [Start time])?
Andrew

3. Re: I want to add minutes to hh:mm field & calculate a new hh:mm result. Here's an example: add 90 minutes to 7:00. Result = 8:30. How do I do this? Thanks.
Mark Holtz Sep 12, 2012 9:00 AM (in response to Andrew Watson)If your data is already a date datatype, Andrew's response of
DATEADD('minute',[Expected Procedure Length], [Start time])
will get you there.
You would need [Expected Procedure Length] to be a field in your data, or you could hard code it as:
DATEADD('minute',90, [Start time])
One additional option would be that you could make [Expected Procedure Length] a parameter as an integer value.
That way, instead of it being static, the user could select from a list of choices or input any value you wish to allow.