Hi
If I save it as a text I wont be able to sum it up to higher level.
I know there is an option in excel: "[h]:mm". it stores the values as 01/01/1900 00:00 and starts to count hours since.
is it possible to use the same method in tm1?
Search found 2 matches
- Thu Mar 12, 2015 5:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TIME DURATION FORMAT
- Replies: 4
- Views: 3795
- Wed Mar 11, 2015 8:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TIME DURATION FORMAT
- Replies: 4
- Views: 3795
TIME DURATION FORMAT
HI
One of my values is time duration for "CALL WAIT TIME". The values are like: 67:15 or 50:59, hours:min. time format is not suitable since the values could get higher than 24.
Please help, is there a special custom format that I can use?
Thanks
One of my values is time duration for "CALL WAIT TIME". The values are like: 67:15 or 50:59, hours:min. time format is not suitable since the values could get higher than 24.
Please help, is there a special custom format that I can use?
Thanks