CODEWITHSUNDEEP
crystal-reportsformula
Dagz200
Dagz200

Reputation: 211

Elapsed time crystal formula

I'm looking to have elapsed time on a report and I'm using this but it does not work– any other suggestions?

If not isnull({table1.end_time}) and not isnull({table1.start_time}) then TimeValue({table1.end_time}) - TimeValue({table1.start_time})

I also tried this

If not isnull({table1.end_time}) and not isnull({table1.start_time}) then Minute({table1.end_time}) - Minute({table1.start_time})

Do I need a conversion of time first?

Thanks in advance

Upvotes: 0

Views: 532

Answers (1)

craig
craig

Reputation: 26262

Try the ElapsedTime function that I wrote.

Upvotes: 1

Related Questions