Add two timefields

[3543e6]

Hi,

I'm using crystal 8.5 and i want to add two timefields with each other.

For instance:
starttime 8:20
duration 1:46

result should be 10:06 and it should also be a timefield like starttime and duration.

Can anyone help me with this?

Thanks

 

[Madawc]

Surprisingly, the command is DateAdd. The database I work on doesn't use time, but DateAdd ("n", duration, starttime) should do it.

Madawc Williams (East Anglia, UK)

 

[lbass]

First convert {table.duration} into minutes by creating a formula {@duration}:

hour({table.duration})*60 + minute({table.duration})

Then use the dateadd function like this, since it requires a datefield:

time(dateadd("n",{@duration},datetime(currentdate,{table.starttime})))

-LB

 

[3543e6]

lbass,

Thanks for your respons. That did it for us. Great!!

regards,
3543e6