Hi!
This function works correctly but the end result is an individual, example show number '5 'but I would like that this number would appear in this time of 00:05.00 as.
(extract(hour,[Business].[Use Deviation].[END_TIMES] )*60+extract(minute,[Business].[Use Deviation].[END_TIMES] ))-(extract(hour,[Business].[Use Deviation].[START_TIMES] )*60+extract(minute,[Business].[Use Deviation].[START_TIMES] ))+_days_between([Business].[Use Deviation].[START_TIMES] ,[Business].[Use Deviation].[END_TIMES] )*1440
any idea? please help with this.
You cound try casting this as an interval hour datatype?
cast([your calc], interval hour)
Then maybe you could specify a time interval format and turn the relevant parts of the time on and off?
Just a thought - I can't verify this at the moment so it's off the top of my head.
MF.