Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Time: more than 24 hours

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

use interval() instead of time()

interval(Endtime-Starttime)

View solution in original post

2 Replies
swuehl
MVP
MVP

use interval() instead of time()

interval(Endtime-Starttime)

Not applicable
Author

That did the trick. Thanks a lot!