Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a throughputtime computed as the difference between starttime and endtime, endtime and starttime are both formatted as dates:
time(Endtime-Starttime).
This works great until the throughputtime is more than 24 hours.. 25 hours and 10 minutes will now be displayed as 1 hour and 10 minutes.
How could I work around this issue? I don't want to add the difference in days because that will mess up other computations.
use interval() instead of time()
interval(Endtime-Starttime)
That did the trick. Thanks a lot!