on 09-02-2008 10:34 AM
Hi,
how do I implement a formula in BEx 7.0 to convert KeyFig "Z_DURATION" which is delivered in hours (eg: 1.5 h) into minutes (90 min). I tried the follwing formula, but encounter a critical error when I use this Mathematical Function logic.
FLOOR(Z_DURATION)60 + FRAC(Z_DURATION)/1060
Is this right? Pls advise. POINTS will naturally be awarded.
SD
Hi SD,
You can just multiply by 60 and calculate. It will result in minutes.
Regards,
aanand
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sebastian,
What is wrong with just using the 1st bit of your calculation FLOOR(Z_DURATION)*60
Does this not give you what you want?
Regards
Nick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.