Converting a number to Time

[r0nniem]

Hi

I've got these fields:
Call Placement Time: 15/06/06 09:15:05
Time To Fix: 1.5 (Number format meaning 1hr 30 mins)

I want to add Time to Fix to Call Placement Time so I can do a countdown of time left to fix.

Can you pleae help?

Thanks
R0nnie

 

[PHV]

Something like this ?
DateAdd("n", 60*[Time To Fix], [Call Placement Time])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Hi,

FYI, TIME values are in units of DAYS.

So if you have a value that represents HOURS, you want to convert hours to days.

New Time: [Call Placement Time] + [Time To Fix] / 24

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}