Calculate date and hours between start and end

[T1na]

In Crystal 11 I would like to calculate the date and hours between a start{datetimefield} and end {datetimefield}. I know about the datediff but need a little help with the time.

 

[lbass]

datediff("h",{table.start},{table.end})

This would return a result in hours. Then you could return days by using:

truncate({@datediff}/24)

The remaining hours would then be:

remainder({@datediff},truncate({@datediff}/24))

-LB

 

[honorbum]

You can always use this:

({end time field} - {start time field})*24 = 0.00 (hrs and .00 mins) use *1440 if you want it in whole minutes.