problem with datas -
11-04-2006
, 10:19 AM
Hi,
I have two problems.
1)I'm using datediff function to count difference in minutes between
two data - and it's working fine.
But I would like to ask if there is any function (or maybe U could tell
me how to do it) that is able to count difference between two data in
minutes, including only days from Monday to Friday and hours from 9:00
am to 5:15 pm.
2)My second question reference to the first one. Let's suppose that
I've managed to count correctly difference between two data. But for
example: 120332 minutes is not telling me a lot. So I would like to
show this measure in this format DD:HH:MM
(DaysDays:HoursHours:MinutesMinutes) - aggregation function for this
measure is SUM.
I was trying to use MDX language to change 120332 into DD:HH:MM and
show this result in report but it didn't work - I don't know how
to do it correctly. Or maybe U have a better idea how I should do it.
Can You help me? |