Add together 2 time fields

[xxThreelionsxx]

Hello

I hope someone can help

I have a table thata contains the following fields StartTime and CallDuration (format hh:mm:ss)

I need to calculate a End time (to show in the same format) for the call and was wondering what the best way to do this is

regards

 

[PHV]

Have you tried this ?
EndTime: StartTime + TimeValue(CallDuration)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[xxThreelionsxx]

Hi PHV

I have tried what you recommed and it is just rerurning #Error

 

[PHV]

What are the field type of StartTime and CallDuration?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[xxThreelionsxx]

Hi PHV Sorry your solution does work , when i was trying a few different things to get it working i had messed around with the data type, having changed it back to date/time it works fine

thanks for your help

 

[SkipVought]

xxThreelionsxx,

Welcome to Tek-Tips

It is customary, when you have recieved a helpful tip that is a valuable post, to locate the link to in that post...
[blue]
Thank Tek-Tip Contributor
for this valuable post![/blue].

The [purple]little purple Stars[/purple] accomplish several important things.

First, it gives positive feedback to contributors, that their posts have been helpful.

Second, it identifies threads as containing helpful posts, so that other members can benefit.

And third, it identifies the original poster (that's YOU, BTW), as a grateful member, that not only receives, but is willing to give tokens of thanks.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}