Formula to convert value to run time time field
Formula to convert value to run time time field
(OP)
Hello,
I am working with SAP Business One production orders and am trying to get report to display a "run time" field that is displayed as time:
I have this formula to calculate the value and the result is a number. ( example 2.5) I now need to try and convert this into a field that shows the total as a run time field.
Screen shot of expected outcome and current report display included:
Any help would be greatly appreciated.
Formula to calculate value (these are all numeric data values):
({Command.PlannedQty}*{Command.BaseQty})/{Command.TimeResUn}
I am working with SAP Business One production orders and am trying to get report to display a "run time" field that is displayed as time:
I have this formula to calculate the value and the result is a number. ( example 2.5) I now need to try and convert this into a field that shows the total as a run time field.
Screen shot of expected outcome and current report display included:
Any help would be greatly appreciated.
Formula to calculate value (these are all numeric data values):
({Command.PlannedQty}*{Command.BaseQty})/{Command.TimeResUn}
Talk To Other Members
RE: Formula to convert value to run time time field
RE: Formula to convert value to run time time field
2.5 what? It appears that it may be 2.5 hours that you want to display as 2:30:00. Yes?
Not being a Crystal Reports guru, but having worked in the SAP environment, I'd guess that there is a Date/Time data type that is based on days. So to convert HOURS to DAYS...
DAYS = HOURS / 24
...with an appropriate DISPLAY FORMAT. That's what I'd do quite handily in Excel.
Skip,
Just traded in my OLD subtlety...
for a NUance!
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein